SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cumilative sum

user520824Dec 15 2008 — edited Dec 15 2008

Hi,
select process_date, sum(result_new_ast) from  edw_owner.essbase_test
group by process_date

gives the below result, now I need a cumulative sum for this query, how do i get it?


PROCESS_DATE	SUM(RESULT_NEW_AST)                 cumilative_sum
11/3/2008 12:00:00.000 AM	133245389.82
11/4/2008 12:00:00.000 AM	173921580.42
11/5/2008 12:00:00.000 AM	152898152.63
11/6/2008 12:00:00.000 AM	129583271.29
11/7/2008 12:00:00.000 AM	125029428.62
11/10/2008 12:00:00.000 AM	131612832.62
11/11/2008 12:00:00.000 AM	108015955.42
11/12/2008 12:00:00.000 AM	128589570.14
11/13/2008 12:00:00.000 AM	206767437.3
11/14/2008 12:00:00.000 AM	182476239.19

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2009

Added on Dec 15 2008

10 comments

285 views