从表A查询出第30到第39条记录
select top 10 * from (select top 39 * from A order by id asc) t order by id desc
select top 10 * from A where id not in (select top 30 id from A order by id asc) order by id asc