select * from (select top 12 * from (select top 20 * from table1 order by id desc) a order by id asc) as b order by id desc
取id 为 9-20 数据然后例序
select * from (select top 12 * from (select top 20 * from table1 order by id desc) a order by id asc) as b order by id desc
取id 为 9-20 数据然后例序