November 5, 2001 at 4:35 am
How can i fetch specific number of records from table? Say a single table has 10000 records without fetching all the records ,if i want to fetch particular number of records say from 400 to 450 ,how can i do that?
November 5, 2001 at 4:53 am
Select Top N is your best bet.
Andy
November 5, 2001 at 4:58 am
Thanx Andy,
But i think u didnt get my question?
Specific number of records say from 400 to 450.HOw can i fetch?
November 5, 2001 at 7:29 am
SELECT * from <tablename>
WHERE recid between 400 and 450
Hope this may help u....
Thiru
November 5, 2001 at 7:41 am
If you have a consistent record id column that would work. Take a look at these two articles (be sure to read both!):
http://www.sqlservercentral.com/columnists/jwiner/returningasubsetofarecordset.asp
http://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply