ARTICLESCLOUD.COM
FOR FREE LEARNING SESSIONS - HOW LAPTOPS WORK - FEEDBACK
 

 

 

Sum with Cumulative Values in Oracle

The following example illustrates how to display sum of values and cumulative values for a given set of data 

SQL>

  select VEHICLE_ID as ID, MONTH_NUMBER as MONTH, COST_OF_REPAIR as cost,
  SUM(COST_OF_REPAIR)  over(order by MONTH_NUMBER) as CUM_COST  from VEHICLE_REPAIR_COSTS
SQL> /

ID              MONTH       COST   CUM_COST
---------- ---------- ---------- ----------
1                   1       1111       1111
2                   2       2222       3333
3                   3       3333       6666

SQL> 

    select VEHICLE_ID as ID, MONTH_NUMBER as MONTH, COST_OF_REPAIR as cost,
   SUM(COST_OF_REPAIR)  over(order by MONTH_NUMBER) as CUM_COST  from VEHICLE_REPAIR_COSTS

SQL> select VEHICLE_ID as ID, MONTH_NUMBER as MONTH, COST_OF_REPAIR as cost, 
  2  SUM(COST_OF_REPAIR)  over(order by MONTH_NUMBER) as CUM_COST  from VEHICLE_REPAIR_COSTS
  3  /

ID              MONTH       COST   CUM_COST
---------- ---------- ---------- ----------
1                   1       1111       1111
2                   2       2222       3333
3                   3       3333       6666

SQL>