Re: How can i accumulate amount using SQL

I have to suggest looking at the SQL reference manuals found on the IBM
site, however,

Select sum(amount) from file.




                                                                           
             "2046 BBQ"                                                    
             <2046bbq@xxxxxxxx                                             
             m>                                                         To 
             Sent by:                  RPG400-L@xxxxxxxxxxxx               
             rpg400-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       How can i accumulate amount using   
             08/09/2006 11:52          SQL                                 
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




 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
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.