SQL Server extracts rows from n to m

Code
N to m rows
1. select top m * from tablename where id not in (select top n id from tablename order by id asc/** // * | desc */)
2. select top m * into temporary table (or table variable) from tablename order by columnname -- Insert the top m pen into the temporary table set rowcount n -- only obtain n results select * from Table variable order by columnname desc
3. select top n * from (select top m * from tablename order by columnname) a order by columnname desc
4. if no other identity columns exist in tablename, a sequence is stored in a temporary table. select identity (int) id0, * into # temp from tablename the n to m statements are: select * from # temp where id0> = n and id0 <= m if you report an error when executing the select identity (int) id0, * into # temp from tablename statement, that's because the select into/bulkcopy attribute in the middle of your DB is not open. First Run: exec sp_dboption your DB name, 'select into/bulkcopy', true
5. If the table contains the identity attribute, select * from tablename where identity_col between n and m
6. SQL2005 starts. you can use row_number () over () to generate a row number. with cte as (select id0 = row_number () over (order by id), * from tablename) select * from cte where id between n to m