AW: How can i accumulate amount using SQL

Hi,

try the following SQL-Statement:

Select   a.Name, sum(a.amount) as Total,          
         (Select   sum(b.amount)                 
             from  test b                      
             where a.Name >= b.Name) as Cumul  
   from  test a                                 
  group  by a.Name                              

Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars." 
(Les Brown) 

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von 2046 BBQ
Gesendet: Mittwoch, 9. August 2006 17:53
An: RPG400-L@xxxxxxxxxxxx
Betreff: How can i accumulate amount using SQL


 i want to do like that in sql

 name      amount     accumulate(amount)
peter         100.00              100.00
John          100.00              200.00
Mary          120.00              320.00