Forum Stats

  • 3,733,167 Users
  • 2,246,708 Discussions
  • 7,856,549 Comments

Discussions

sql update

0614
0614 Member Posts: 115 Red Ribbon
edited December 2019 in SQLcl

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

0614

Best Answer

Answers

Sign In or Register to comment.