代码如下：
declare @PageSize int;declare @PageNum int;set @PageSize = 20;set @PageNum = 300;--------------------------------------------------select *from (select ROW_NUMBER() over(order by Created desc) as RowNumber ,*from T_Api_TB_Trade) as tbwhere RowNumber between ((@PageNum - 1) * @PageSize + 1) and (@PageSize * @PageNum)--------------------------------------------------
转载于:https://www.cnblogs.com/xiebin1986/archive/2012/03/01/2375972.html
