Roy mm


Hello.
I have a query That look like that:

"SELECT COUNT(*),MONTH FROM TABLE GROUP BY MONTH"

The result is:
Jun 2
Feb 2
Mar 3
Apr 0
May 5

What I want to have is that every month will sum up the previous month and him self so in the end I will be able the create a graph wuth those numbers:

Jun 2
Feb 4
Mar 7
Apr 7
May 13

Any ideas on how to start



Re: sum up number on the time line

Roy mm


I found a great query in another fourm:

SQL> select b.sal,sum(a.sal) as cum_sal
2 from emp a,emp b
3 where a.rowid <= b.rowid
4 group by b.rowid,b.sal
5 /

Thanks.