select top size * from procedures where id<=(select top 1 id from (SELECT TOP (page-1)*size+1 ID FROM procedures ORDER BY ID DESC) order by id) order by id desc
本文共 209 字，大约阅读时间需要 1 分钟。
select top size * from procedures where id<=(select top 1 id from (SELECT TOP (page-1)*size+1 ID FROM procedures ORDER BY ID DESC) order by id) order by id desc
转载于:https://my.oschina.net/haochenhh/blog/198735