declare @page int=1000000 -- 页码
declare @pageSize int=30 -- 页数
;with data_cte as
(
    select ROW_NUMBER () over(order by id desc)‘rn‘,*
    from orders(nolock) 
)
select (select COUNT(0) from data_cte)‘Count‘,*
from data_cte aa
where aa.rn between (@page-1)*@pageSize+1 and @page*@pageSize
order by rn