数据库分页

declare 
@PageNumber AS INT,
@RowNumber AS INT

SET @PageNumber=3
SET @RowNumber=50

SELECT [a].[Id]
FROM [AppBooks] AS [a]
ORDER BY [a].[Name]
OFFSET ((@PageNumber-1)*@RowNumber) ROWS
FETCH NEXT @RowNumber ROWS ONLY;

 

如果数据量大，分页查询慢，最好建立非聚集索引，order by之后的字段