The ability to implement Limit m,n in SQL Server

In MySQL and SQLite, you can use the limit to query the record of the nth bar, such as SELECT * FROM MyTable limit 1, 3, but the limit statement is not supported in SQL Server, SQL Server supports top, You can use the nesting of top to achieve the same functionality as limit.

To fetch the first 10 records in the MyTable table, the statements in SQL are as follows: Select top from MyTable

If you want to query the 11th to 18 records in the MyTable table, the statements in SQL are as follows:

Select Top 8 * from Mytalbe where FID not in (select Top ten from mytable);

This statement is equivalent to the SELECT * FROM MyTable limit 10, 8 in SQLite;