Need SQL to calculate Running Sum in Oracle

[anedra]

Hi,

I'm looking for SQL examples to calculate the running sum in Oracle:
Activity Running Sum
Account100 50.00 50.00
Account200 75.00 125.00
Account300 25.00 150.00

The Account information is stored in a typical dimension table and the activity is stored in a Fact table. How might I calculate the running Sum column?

Thanks,
Anedra

 

[lewisp]

Use a summary column, as a 'sum', in the same group as your amount column and reset it at report level.

 

[sem]

You may also consider analytic variant of sum function:

select 
  activity, 
  amount, 
  sum(amount) over (ORDER BY activity) cumulative
from activities

Regards, Dima

http://seminihin.narod.ru