Re: Cumulative running total

Yes, an Gints' as well as mine deliberately omit the AS row for period 1. That is because the current solution wouldn't have it either. For period 1 it is simply a select a, b, year, 1, sum(amount) from test where year=blah and period <= 1 group by 1, b, year
so if there is no row for any a-b values for that year and period 1 it is not in the resultset. 

The replacement solution should provide the same results.

At 11:32 AM 10/31/2008, Gints Plivna wrote:

Yes because it wasn't also in Wolfgang's initially provided desired
result set and is filtered out by WHERE alt_b IS NOT NULL.
Anyway as I understood Wolfgang already succesfully solved his problem.

Gints Plivna
http://www.gplivna.eu

2008/10/31 Michael Moore <michaeljmoore@xxxxxxxxx>:
> let me try again...
> not sure if this matters, but there is no AS for period 1 in the result set
> for Gint's first solution.
> Mike


Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: