Hi all,
I need a small help in sql update query
please follow below structure
table
S.no Name sal (sal+increment ) incsal
1 a 100 100
2 b 200 300(1st row value+ 2nd row value)
3 c 300 500 (2nd row value + 3rd row value)
4 d 400 700 (3rd row value + 4th row value)
need update statement for incsal column value to update as mentioned above
Thanks in advance