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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Record Paging

Author  Topic 

olily
Starting Member

37 Posts

Posted - 2002-07-23 : 19:48:48
If I want to select first 20 records, then second 20 records, then third 20 records until all the records are selected. Then repeat the process again. From time to time, there will be new or deleted record. Meaning recordcount might increase or decrease. How can I do so using sql statement? Thanks.

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-07-23 : 20:16:54
Read Graz's article What's After Top?

Go to Top of Page
   

- Advertisement -