select * from (select ROW_NUMBER() over (order by 排序字段) as myNum,* from (select top(num1) * TableName ) t1 ) t2 where myNum>num2 --num1 的来源 ((当前页索引 -1)* pageSize ) +pageSize ) --num2的来源(当前页索引 -1)* pageSize )
追加一个 select * from 表 order by id OFFSET PageIndex*pagenum ROWS FETCH next pagenum rows only 需要sql server 2012+