利用SQL Server 2005的ROW_NUMBER()函数，按orderID字段逆序排列，给Orders表生成行号的语句如下：
SELECT ROW_NUMBER() OVER(ORDER BY ordered DESC) AS rownum, ordered
SELECT ROW_NUMBER() OVER(ORDER BY ordered DESC) AS rownum, ordered
FROM Orders
ORDER BY rownum DESC
|
|
|
管理
|