Re: Group by question...

select
  max(decode(t1.MonthYear, t2.MonthYear, t1.Amount, 0)) Amount,   t2.MonthYear,
  sum(t1.Amount) Amount
 from Your_Table t1, Your_Table t2
 where
  t1.MonthYear<=t2.MonthYear
 group by
  t2.MonthYear
 order by
  t2.MonthYear
;
--
 Alexander I.Doroshko, aid_at_grant.kharkov.ua

• Bank "Grant", Kharkov, Ukraine kevinmz_at_my-deja.com wrote in article <7kaqtq$i1b$1_at_nnrp1.deja.com>... <skipped>
  : Amount MonthYear
  : ------ ---------
  : 100 Dec-1996
  : 223 Jan-1997
  : 123 Jun-1997
  : etc...
  :
  : How do I get a cumulative total for each row that
  : includes all the values for the current row and
  : all previous rows (sorted by date).
  :
  : Example:
  : Amount MonthYear Cumulative
  : ------ --------- ----------
  : 100 Dec-1996 100
  : 223 Jan-1997 323
  : 123 Jun-1997 446
  : etc.