ROW_NUMBER()用法

WITH OrderedOrders AS
(select *,ROW_NUMBER() OVER(ORDER BY ncid ) AS RowNumber from [Sheet11$])
SELECT *
FROM OrderedOrders
WHERE RowNumber between 50 and 60;

WITH OrderedOrders AS
(select *,ROW_NUMBER() OVER(ORDER BY ncid ) AS RowNumber from [Sheet11$])
update OrderedOrders set cid=RowNumber