title: How to update a column's value using row number in Teradata
body: <p>I want to update a column's value in this way</p>
  
  <pre><code>new value  = old value + row_number() * 1000
  </code></pre>
  
  <p>also for row_number I want to use order by old value</p>
  
  <p>but I didn't find any solution.</p>
  
  <p>sample data</p>
  
  <pre><code>column    
     1
     3
     5
  </code></pre>
  
  <p>after update query it should be</p>
  
  <pre><code>column
    1001
    2003
    3005
  </code></pre>