Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RichardSteele
Posting Yak Master
160 Posts |
 Posted - 2003-05-22 : 10:42:57
|
| I know how to retrieve top x records from a table. How would one return middle x records? For example, I need to return rows starting with the 51st row and continuing through the 100th row. Is this possible using a top like syntax or must I use a where clause, where primarykeycolumnname>50 and primarykeycolumnname< 101? Thanks in advance. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-22 : 10:48:25
|
| See article "What's after top"Search the forums on record paging or top n there have been quite a few discussions in the last week. |
 |
|
|
|
|
|
Retrieving x records