I have one in my DB and some like below
Name Num
---- ------
A 201
B 202
C 203
D 204
E 205
I want to change the order of “E” and reorder the table data as below
Name Num
---- ------
A 201
B 202
E 203 - "E" shifted in between "B" and "C", hence Num also got modified to 203"
C 204
D 205
Thanks in advance.
1