sql2005中用row_number()...over(order by..)找插入数据顺序.txt

来自「SQL语言常用的一些命令各代码」· 文本 代码 · 共 14 行

USE AdventureWorks;
GO
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;


该方法只适合SQL2005，在SQL2000中只有考虑select identity(int,1,1) ,* into #aa from table

这样的临时表实现了。