Looking for effective solution for sum
Posted: Mon Apr 14, 2014 2:17 am
I have to find the sum of salaries of all employees and this sum should repeat for all the rows.
The output should look like as
i/p:
employee_id, salary
-------------------------------
10, 1000
20, 2000
30, 3000
40, 5000
o/p
employee_id, salary, salary_sum
-------------------------------
10, 1000, 11000
20, 2000, 11000
30, 3000, 11000
40, 5000, 11000
I am able to achieve the o/p with the help of job sequence by using two jobs after writing
into intermediate file.Just want to know is there any way to get required o/p with one parallel
job?
The output should look like as
i/p:
employee_id, salary
-------------------------------
10, 1000
20, 2000
30, 3000
40, 5000
o/p
employee_id, salary, salary_sum
-------------------------------
10, 1000, 11000
20, 2000, 11000
30, 3000, 11000
40, 5000, 11000
I am able to achieve the o/p with the help of job sequence by using two jobs after writing
into intermediate file.Just want to know is there any way to get required o/p with one parallel
job?