使ç¨ROW_NUMBER() OVER (PARTITION BY ColName ORDER BY) æ¥è·å¾è¡å·ã
为äºä»£ç æ´æ¸
æ°ï¼å¯ä»¥ä½¿ç¨CTEï¼
--ä¾å---------
WITH OrderedOrders AS
(
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
FROM Sales.SalesOrderHeader
)
SELECT *
FROM OrderedOrders
WHERE RowNumber BETWEEN 50 AND 60;
温馨提示:内容为网友见解,仅供参考