Click to See Complete Forum and Search --> : SQL Server 2000 Row Limits


cancer10
07-02-2007, 06:50 AM
i All,

I have 20,000 records in my database

Is there any way i can run a sql query that can fetch the first 5000 row, then the next 5000 row and so on?

I do not want to fetch 20,000 rows at a time.


Plz help.


THanx