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 ,i use following query. select variablename from table1 order by variablevalue Asc. i see sorting result in Result part when i execute my query but i can not move to third column.
What do you mean by putting the sorting result in the third column? What exactly is supposed to go in that column?