ruwnumber自定义分页

declare @pageIndex int

declare @startRowIndex int
declare @maximumRows int

set @pageIndex=5

set @startRowIndex=0
set @maximumRows=1000

set @startRowIndex=(@pageIndex-1)*@maximumRows+1

select ProductID,ProductName,AuthorNames,ManufacturerName,RowRank
from (
  select ProductID,ProductName,AuthorNames,ManufacturerName,row_number() over(order by ProductID) as RowRank
  from Products
) as ProductsWithRowNumbers
where RowRank >= @startRowIndex
  and RowRank < (@startRowIndex + @maximumRows)