If I have a table like the one below:
| Iteration | Score |
|---|---|
| 1 | 20 |
| 2 | 87 |
| 3 | 10 |
I reordered by Score descending:
ordered: `Score desc first_table;
| Iteration | Score |
|---|---|
| 2 | 87 |
| 1 | 20 |
| 3 | 10 |
How can I then renumber the Iteration column, so the output is something like below? I am thinking of creating a new column that gets the index # of every row, then replacing the original Iteration column.
| Iteration | Score |
|---|---|
| 1 | 87 |
| 2 | 20 |
| 3 | 10 |
>Solution :
You can sort the columns not the table:
update asc Iteration, desc Score from tab