Question

从sql server 数据库里创建一个表，这个表里存有10条数据，怎么样取出第5条到第7条记录？ 谢谢

Answer 1

SELECT * FROM A WHERE a_id IN ( SELECT TOP 5 a_id FROM A WHERE a_id IN ( SELECT TOP 7 a_id FROM A ) ORDER by a_id DESC) ORDER BY a_id

Answer 2

select top 2 * from tb where id not in(select top 5 id from tb order by id)