[RBForums] Databases: SQLite SELECT running total?

[rbforumnotifier]

New topic in Databases: 

SQLite SELECT running total?

RBkanso - Tue Jun 10, 2008 8:35 pm

<http://forums.realsoftware.com/viewtopic.php?t=22847>
                                                                                
                                                                                
Suppose I have the following query:

SELECT Idx, Item, Cost FROM t1

Which gives me this output:
Code:
Idx  Item   Cost
1    Apples 2.00
2    Pears  1.00
3    Grapes 3.00


Is there a SELECT statement that can get me a running total? The query output 
would look like this:
Code:
Idx  Item   Cost Total
1    Apples 2.00 2.00
2    Pears  1.00 3.00
3    Grapes 3.00 6.00

                                        
                                                                                
                                                                                
                                                                                
                                                                                
                                        




-- 
Over 900 classes with 18000 functions in one REALbasic plug-in. 
The Monkeybread Software Realbasic Plugin v8.1. 

&lt;http://www.monkeybreadsoftware.de/realbasic/plugins.shtml&gt;

rbforumnotifier@monkeybreadsoftware.de