如何使用SQL Server中的Row_number()函数以相反顺序生成序列号

Question

我正在使用SQL在SQL Server 2008中生成序列号

SELECT  ROW_NUMBER() OVER ( ORDER BY Column ) AS SrNo

SQL上方将在上升顺序中生成SRNO

1 2 3 4 5

，但我想以降序生成它。

5 4 3 2 1

Answer 1

您需要按列desc

对顺序进行排序

SELECT SrNo FROM
(SELECT ROW_NUMBER() OVER (ORDER BY YOUR_COLUMN ) AS SrNo FROM YOUR_TABLE) X
ORDER BY SrNo DESC

Answer 2

select * FROM (
  SELECT  ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS SNO, ColumnName FROM table
 )r
 ORDER BY SNO Desc