摘要:
declare @PageSize int,@PageIndex int;set @PageSize=5;set @PageIndex=2;WITH Pagination AS( SELECT *,ROW_NUMBER() OVER(ORDER BY PGTQ) AS RowNumber FROM表 where 条件)SELECT * FROM Pagination WHERE RowNumberBETWEEN @PageSize*(@PageIndex-1) + 1 AND @PageSize * @PageIndex;结果为 每页显示5条,第二页的数据 阅读全文