Forum Stats

  • 3,741,213 Users
  • 2,248,391 Discussions
  • 7,861,674 Comments

Discussions

sql update

0614
0614 Member Posts: 117 Red Ribbon
edited Dec 9, 2019 3:37AM 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.