cumulative aggregation in a query

[tamilselvan]

Here is an example:

SQL> select * from t1 ;

    ORD_ID ORD_DATE                ORD_AMT
---------- -------------------- ----------
         8 15-dec-2004 09:56:48        200
         1 15-dec-2004 09:56:58         25
         2 15-dec-2004 09:57:30         50
         9 15-dec-2004 09:57:39        225
         7 15-dec-2004 09:57:48        175
         5 15-dec-2004 09:58:03        125
         4 15-dec-2004 09:58:25        100
         3 15-dec-2004 09:59:32         75
         6 15-dec-2004 10:11:24        150

9 rows selected.

SQL> get ana
  1  select ord_date, ord_id, ord_amt,
  2         sum(ord_amt) over (
  3         order by ord_id range unbounded preceding) cum_sale
  4* from t1
SQL> /

ORD_DATE                 ORD_ID    ORD_AMT   CUM_SALE
-------------------- ---------- ---------- ----------
15-dec-2004 09:56:58          1         25         25
15-dec-2004 09:57:30          2         50         75
15-dec-2004 09:59:32          3         75        150
15-dec-2004 09:58:25          4        100        250
15-dec-2004 09:58:03          5        125        375
15-dec-2004 10:11:24          6        150        525
15-dec-2004 09:57:48          7        175        700
15-dec-2004 09:56:48          8        200        900
15-dec-2004 09:57:39          9        225       1125

9 rows selected. 

Tamil