sql 查询记录数结果集某个区间内记录

以查询前20到30条为例,主键名为id 方法一: 先正查,再反查 select top 10 * from (select top 30 * from tablename order by id asc) A order by id desc 方法二: 使用left join select top 10 A.* from tablename A left outer join (select top 20 * from tablename order by id asc) B on A.id = B.id where B.id is null order by A.id asc 方法三: 使用