select top pageSize, * from (SELECT row_number() over(order by id desc) as rownumber,*
FROM tb1) A where rownumber > (pageIndex-1)*pageSize本文共 190 字，大约阅读时间需要 1 分钟。
select top pageSize, * from (SELECT row_number() over(order by id desc) as rownumber,*
FROM tb1) A where rownumber > (pageIndex-1)*pageSize转载于:https://www.cnblogs.com/donchen/p/7256517.html