finding sum of salary from employee table

I’m having the data in data base like in the below.

Emp_id Ename Sal 
11      AAA   10
22      BBB   20
33      CCC   30
44      DDD   60

​x
 
Emp_id Ename Sal 11      AAA   1022      BBB   2033      CCC   3044      DDD   60​

Then i want to populate a new column as in the below.

Emp_id Ename Sal  New_column
11      AAA   10    10  --> 10+0
22      BBB   20    30  --> 10+20
33      CCC   30    60  --> 10+20+30
44      DDD   60    120 --> 10+20+30+60

 
Emp_id Ename Sal  New_column11      AAA   10    10  --> 10+022      BBB   20    30  --> 10+2033      CCC   30    60  --> 10+20+3044      DDD   60    120 --> 10+20+30+60​

Thank you for the help in adavance!

Answer

If you can use Window analytic function within your DBMS, then use :

select t.*, sum(sal) over (order by emp_id) as New_column 
  from tab t
 order by emp_id

 
select t.*, sum(sal) over (order by emp_id) as New_column   from tab t order by emp_id ​

Advertisement

Answer