For example, I have a table

value      position
300            1
100            2
500            3
200            4

I have to update position ordered by value, and table must look like this

value      position
300            3
100            1
500            4
200            2

Is it possible to make such update in single query?

Reply via email to