title: sorting data and move to new columns in sql
body: <p><a href="https://i.stack.imgur.com/PK91S.jpg" rel="nofollow noreferrer">enter image description here</a>I have  three columns in sql. First column include variable name and second column include variable value. I want to sort variable name based on its values and put sorting result in third column. For doing this, I used following query. </p>
  
  <pre><code>select variablename
  from table1
  order by variablevalue Asc
  </code></pre>
  
  <p>I  see sorting result in Result part when i execute my query but i can not move to third column.</p>