Subject Re: [firebird-support] How to do a running total in SQL
Author Mark Rotteveel
In Firebird 3 it will be possible with window functions. In Firebird 2.5 I don't know a way in pure SQL.


----- Reply message -----
Van: "Maya Opperman maya@... [firebird-support]" <>
Aan: "" <>
Onderwerp: [firebird-support] How to do a running total in SQL
Datum: vr, okt. 23, 2015 08:40



I’d like to add a running total to my result set. For example:


Table: Invoices


Reference           Due

Invoice1               50.00

Invoice2               30.00

Invoice3               20.00


I’m guessing SQL would be something like:




Sum_Total(Due) as Balance

From Invoices


Desired Result:

Reference           Due                        Balance

Invoice1               50.00                     50.00

Invoice2               30.00                     80.00

Invoice3               20.00                     100.00


I know I can do this quite easily from within a selectable stored procedure, but the problem there is the running total won’t be correct if a different sort order is specified, which happens often in my real world application.


Is it possible to do this using just a simple SQL statement?