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

Joerg.Sobottka

I would write a small PL/SQL for that.

Joerg.Sobottka

I would write a small PL/SQL for that.

john_ebenezer

Hi

You can use the analytical function to achieve the same result in SQL. Below is the query to achieve the same.

SELECT name, sal, SUM (sal) OVER (ORDER BY sal) running_total

  FROM table_name;

Thanks

John