Comparison

[harishgorli]

Id,Amount,required column

1,20, min(20-30,20-40)

2,30,min(30-20,30-40)

3,40,min(40-30,40-20)

(Required column )like in front end as table column comparing itself

Final table

1,20,-20

2,30,-10

3,40,10