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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-18 : 18:16:53
|
labatman writes "MS SQL uses TOP in the select statement. We would like to know how to return the 20th to the 30th record in a select statement. This is useful when developing a website and you don't want the surfer to return all the records or the top records, but you want that person to page through the records.
eg 10-20 on first page
21-30 on second page
...
81-87 on last page
How do you configure a select statement to limit the data this way?
Thanks
ps using SQL Server 2k on win 2k adv server." |
|
|
|
|
|
select records 20 - 30 of recordset