select top 12 * from (select top 24 * from table order by id ) order by id desc 先正序取前24条,再倒序取其中的前12条 ,25-36之间在数据改一个地方:select top 12 * from (select top 36 * from table order by id ) order by id desc
需要一个排序字段 select top 25* from (select top 36* from table1 order by id)order by id desc select * from table1 t1 where (select count(*) from table1 where id<t1.id) between 11