Re: AW: How can i accumulate amount using SQL

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