How to Implement the Limit m and n functions in SQL Server

In MySQL, you can use Limit to query records from column m to column n. For example:
Copy codeThe Code is as follows:
Select * from tablename limit m, n

However,The Limit statement is not supported in SQL Server. What should we do?
Solution:
Although SQL Server does not support Limit, it supports TOP.
Taking SQL Server 2005 as an example, we use its own demo database AdventureWorks as the test data:
Copy codeThe Code is as follows:
Select id from tablename

If you want to query the first six records in the preceding results, the corresponding SQL statement is:
Copy codeThe Code is as follows:
Select top 6 id from tablename

If you want to query 7th to 9th records in the preceding results, the corresponding SQL statement is:
Copy codeThe Code is as follows:
Select top 3 id from tablename
Where id not in (
Select top 6 id from tablename
)

Copy codeThe Code is as follows:
Select top (n-m + 1) id from tablename
Where id not in (
Select top M-1 id from tablename
)

Copy codeThe Code is as follows:
Select top @ pageSize id from tablename
Where id not in (
Select top @ offset id from tablename
)