Hi, using Oracle 11g r2.
I know how to generate running totals like using the following query. However, I need to add a quantity to the first value of every group, then generate the running total.
SELECT EMPloyee_id,
upper(employee_title),
SAL,
SUM(SAL) OVER(PARTITION BY upper(employee_title) ORDER BY EMPloyee_id RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RUNNING_TOTAL
FROM EMPloyee
The following output is produced
empID title salary running_total
1 DEVELOPER 1000 1000
2 DEVELOPER 1000 2000
7 DEVELOPER 1000 3000
10 DEVELOPER 1000 4000
3 DEVELOPMENT MANAGER 1000 1000
5 PROD SUPPORT 1000 1000
6 PROD SUPPORT 1000 2000
8 PROD SUPPORT 1000 3000
9 PROD SUPPORT 1000 4000
Required output
empID title salary running_total
1 DEVELOPER 1000 2000(add 1000 to first quantity)
2 DEVELOPER 1000 3000
7 DEVELOPER 1000 4000
10 DEVELOPER 1000 5000
3 DEVELOPMENT MANAGER 1000 2000 (add 1000 to first quantity)
5 PROD SUPPORT 1000 2000 (add 1000 to first quantity)
6 PROD SUPPORT 1000 3000
8 PROD SUPPORT 1000 4000
9 PROD SUPPORT 1000 5000