2 Replies Latest reply on Dec 9, 2019 8:37 AM by john_ebenezer

    sql update

    0614

      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