sql高效分页语句

1、根据主键通过rowNumber函数排序，取出当前页取数范围
2、然后通过主键取关键查询表

declare @PageSize int =10;
declare @PageIndex int =2;
select p2.RowNum, p1.* from ProductInfo p1,
	(
	select top (@PageIndex*@PageSize) (row_number() over(order by id desc)) as RowNum, id from ProductInfo
	) p2
where p1.id=p2.id and p2.RowNum>(@PageIndex-1)*@PageSize order by p2.RowNum desc