sql的ROW_NUMBER()函数分页

SELECT * FROM(SELECT  [Id]
      ,ROW_NUMBER() OVER(ORDER BY id) AS row_number
FROM [DeliveryDate]) AS a
WHERE row_number BETWEEN 1 AND 2

row_number（）函数进行编号