sql分页

declare @sizePage int=3

declare @currentPage int=2

select top 3 * from ( select ROW_NUMBER() over(order by ID asc) as RowNumber ,*from Product) as temp

where RowNumber>(@currentPage-1)*@sizePage