How to select limted data in mssql

Question

I have a huge data in my table so I want to fetch it in parts. So I am trying to run

select top 1000 from table_name

It's giving me the top 1000 data but what will be the query if I want the next 1000 data. It's just returning me the first 1000 data.

You can use While loop like any other programming language if you want to process in batches. — Rajat Jaiswal, May 25 '21 at 05:33

score 1 · Answer 1 · answered May 25 '21 at 04:58

1

This is answered here: https://stackoverflow.com/a/5884057/11967866

SELECT  *
FROM    (
        SELECT  *,
                ROW_NUMBER() OVER (ORDER BY mycolumn) rn
        FROM    mytable
        ) q
WHERE   rn BETWEEN 1001 AND 2000
ORDER BY
        mycolumn

answered May 25 '21 at 04:58

Jaskirat Singh

79
5

What if i have joining as well? Do i just need to do it on main table – Vivek Modi May 25 '21 at 05:12

score 1 · Accepted Answer · answered May 25 '21 at 05:27

1

You can use ROW_NUMBER()

or you can simply use this.

select top(1000) * from Table_Name where Column_Name NOT IN (select top (1000) Column_Name  from Table_Name)

answered May 25 '21 at 05:27

Gokul Vasudevan

71
2

How to select limted data in mssql

2 Answers2