title: convert row_number() to int in sql server
body: <p>I have a query where i have used row_number() function. My query is like the following</p>
  
  <pre><code>SELECT ID, 
  ROW_NUMBER() over(order by Position desc) Rank
  FROM Tbl
  </code></pre>
  
  <p>Problem is Rank is producing a bigint value. But i want to convert it to an int. How can i do it?</p>