In Firebird 3 it will be possible with window functions. In Firebird 2.5 I don't know a way in pure SQL. Mark
----- Reply message ----- Van: "Maya Opperman [email protected] [firebird-support]" <[email protected]> Aan: "[email protected]" <[email protected]> Onderwerp: [firebird-support] How to do a running total in SQL Datum: vr, okt. 23, 2015 08:40 Hi, 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: Select Reference, Due, 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? Thanks Maya
