select next rows in sql [closed]

Question

I have more records in my database. so I want to select first 10,000 record. Then i have to continue the selection from next records means next 10,001 to till some values. How to put query here?

Any idea means helpful to me.

Answer 1

If you havent ID row in your table, or ID isn't IDENTITY, you can use ROW_NUMBER function like this:

SELECT ROW_NUMBER() OVER (ORDER BY Products.ProductID) as 'rownbr', Products.ProductID
FROM Products
ORDER BY Products.ProductID

and then just use WHERE clause like this:

SELECT ROW_NUMBER() OVER (ORDER BY Products.ProductID) as 'rownbr', Products.ProductID
FROM Products
WHERE rownbr BETWEEN 10000 and 20000
ORDER BY Products.ProductID

Answer 2

First 10,000 Records and then rest of records;

SELECT TOP 10000 * FROM table ORDER BY Id
DECLARE @count int;
SET @count = (SELECT COUNT(*)  FROM table);
SELECT TOP (@count - 10000) * FROM table ORDER BY Id DESC;