sqlserver-分页查询

分页

DECLARE @PageSize INT = 10;   -- 每页行数
DECLARE @PageIndex INT = 3;   -- 当前第几页,从1开始

select CEILING(1.0 * TotalCount / @PageSize) TotalNum,* from 
(
SELECT 
    id
		lastname,
    (select count(1) from HrmResource) AS TotalCount,     -- 总记录数
    @PageIndex AS CurrentPage,     -- 当前页
    @PageSize AS PageSize          -- 每页大小
FROM HrmResource
ORDER BY id
OFFSET (@PageIndex - 1) * @PageSize ROWS
FETCH NEXT @PageSize ROWS ONLY
) aa where 1=1