Write out an SQL statement: Take the 31st to 40th record in table A (SQL Server, with an auto-growing ID as the primary key, note: The ID may not be contiguous

Http://blog.sina.com.cn/s/blog_a342ff0a0101u3kb.html

SQL Server:

Solution 1:select Top * from a where ID not in (select top with ID from a);

Solution 2:select Top * from a Where ID > (select MAX (ID) from (select top with ID from a) as A);

As I understand it,

The first method: first 30 data (the default positive order) is queried based on the ID, and then the first 10 data in the 30 data is queried in the positive order.

The second method: first, according to the ID positive sequence query the top 30 data, the ID of the largest data ID, and then query Id>max (ID), that is, to obtain the data to be queried.

Write out an SQL statement: Take the 31st to 40th record in table A (SQL Server, with an auto-growing ID as the primary key, note: The ID may not be contiguous