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
本文标题:SqlServer 高性能分页查询写法
本文链接:https://www.haomeiwen.com/subject/vybswdtx.html
网友评论