title: How to use ROW_NUMBER with order by
body: <pre><code>SELECT *
  FROM My table A
  ORDER BY ROW_NUMBER() OVER(ORDER BY 1)
  </code></pre>
  
  <p>While using this getting error as 
  Windowed functions and NEXT VALUE FOR functions do not support integer indices as ORDER BY clause expressions.</p>
  
  <p>How i can make it work.</p>
  
  <p>TIA</p>