对无ID(或者ID不规则)的表进行分页操作,可以使用row_number()函数分页
WITH OrderedOrders AS(SELECT *,ROW_NUMBER()
OVER (order by Number)as RowNumber FROM dbo.xfd )
SELECT * FROM OrderedOrders WHERE RowNumber between 1 and 50