Re: AW: How can i accumulate amount using SQL

["Raul A. Jager W." <raul@xxxxxxxxxx>]

I remember reading about UDF that can hold some info from call to call, 
but I have never used it.  Sounds worht to investigate, once you find 
out how, a simple function will do what yuo need.

HauserSSS wrote:

> 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
>