title: How to generate Serial Number in reverse order with ROW_NUMBER() function in sql server
body: <p>I am using SQL to generate Serial number in SQL server 2008</p>
  
  <pre><code>SELECT  ROW_NUMBER() OVER ( ORDER BY Column ) AS SrNo
  </code></pre>
  
  <p>Above SQL will generate SrNo in the ascending order</p>
  
  <blockquote>
    <p>1 2 3 4 5</p>
  </blockquote>
  
  <p>but I want to generate it in descending order.</p>
  
  <blockquote>
    <p>5 4 3 2 1</p>
  </blockquote>