im having table x with two column "mark and rank"
mark  rank
24
55
34
67
48

now i want to fix the rank based on the marks
ie i want an update statement which will set the rank based in ranks

the o/p shd be

mark rank
24   5
55   2
34   4
67   1
48   3