Select top, how to get the rest?

Question

Post reply

Select top, how to get the rest?

fiaolle

SSC Enthusiast

Points: 163
More actions
March 23, 2010 at 2:14 pm

#386564

Hi
I want to use paging and I don't want to get so many records.
But if I use select top (100) for example, how will I get the rest of the records, split in 100 per each select query. I have seen example like this
SELECT TOP (100) OrderDate, ShipName FROM orders WHERE orderID NOT IN (SELECT TOP OFFSET OrderID FROM orders)
. But I have read and tried that Offset doesn't work in SQL Server. Is there anything else I can do?
Thanks
Fia

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Start by reading this article: http://www.sqlservercentral.com/articles/Advanced+Querying/3181/

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 2

This one[/url] might be of interest too.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

samantha 54746 Newbie Points: 3 More actions · Answer 3

You can check this SQL Data with REST interface[/url] or can work out your own code with testing environment of SQL server debugging[/url].

OTF SSCertifiable Points: 6104 More actions · Answer 4

As an FYI, the use of OFFSET in the ORDER BY Clause would be valid for SQL Server 2012.

http://technet.microsoft.com/en-us/library/ms188385.aspx