Question

写出一条Sql语句：取出表A中第31到第40记录（SQLServer,以自动增长的ID作为主键,注意：ID可能不是连续的。

Answer 1

select top 10 * from A where id not in (select top 20 id from A )
查询前10条 数据（Id不在前20 的数据）的所有信息

Answer 2

【有疑问可以HI我，或追问，但请不要关闭问题，谢谢！】
select top 10 * from (select top 40 * from a order by id asc) top_n order by id desc

Answer 3

select top 10 * from (select top 40 from tablename order by ID) order by ID

Answer 4

try row_number to control 31 to 40

Answer 5

select top(10) * from table where id not in(select top(30) id from table)

Answer 6

select top 10 * from tablename
where ID in (select top 40 ID from tablename)
order by ID desc