首页 > 代码库 > ROW_NUMBER

ROW_NUMBER

技术分享
SELECT ROW_NUMBER() OVER(ORDER BY ordered DESC) AS rownum, ordered
FROM Orders

ORDER BY rownum DESC
View Code

 

ROW_NUMBER