Re: How can i accumulate amount using SQL

have tried  the SQL statemnt but can't work
message : Column *N or expression specified in SELECT list not valid.   

 

date: Wed, 09 Aug 2006 15:28:11 -0400
from: "Raul A. Jager W." 
subject: Re: AW: How can i accumulate amount using SQL

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