本文介绍如何使用SQLServer2005的ROW_NUMBER()函数为Orders表中的记录按orderID字段逆序排列并生成行号。具体实现方式是通过SELECT ROW_NUMBER() OVER(ORDER BY ordered DESC) AS rownum, ordered FROM Orders ORDER BY rownum DESC。
SELECT ROW_NUMBER() OVER(ORDER BY ordered DESC) AS rownum, ordered
FROM Orders
ORDER BY rownum DESC
利用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
转载于:https://www.cnblogs.com/yingying0708/archive/2012/03/27/2420113.html
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
