How to generate Serial Number in reverse order with ROW_NUMBER() function in sql server

Question

I am using SQL to generate Serial number in SQL server 2008

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

Above SQL will generate SrNo in the ascending order

1 2 3 4 5

but I want to generate it in descending order.

5 4 3 2 1

Answer 1

You need to sort the ORDER BY column DESC

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