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)
 Obtain a portion of rows in a select

Author  Topic 

jweizman
Starting Member

27 Posts

Posted - 2002-01-25 : 06:43:56
Hi

I know i can do a Select Top n first items

What i want to 'page'. I mean get the records from 20-->30 then 30-->40 ?

Thanks
Jonathan

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2002-01-25 : 06:54:04
See http://www.aspfaqs.com/webtech/062899-1.shtml or http://www.15seconds.com/Issue/010308.htm

Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-01-25 : 09:03:11
searching here for 'whats after top' may also give you a workable solution to your problem.

Go to Top of Page
   

- Advertisement -