SqlServer 高性能分页查询写法
2023-11-15 本文已影响0人
Messix_1102
DECLARE
@PageIndex INT = 1,
@PageSize INT = 10
SELECT *
FROM Student
ORDER BY Id
OFFSET (@PageIndex - 1) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY
DECLARE
@PageIndex INT = 1,
@PageSize INT = 10
SELECT *
FROM Student
ORDER BY Id
OFFSET (@PageIndex - 1) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY