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.
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
November 5, 2001 at 4:58 am
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....
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!):
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply