|Subject||Re: [firebird-support] How to do a running total in SQL|
Van: "Maya Opperman maya@... [firebird-support]" <firstname.lastname@example.org>
Aan: "email@example.com" <firstname.lastname@example.org>
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:
I’m guessing SQL would be something like:
Sum_Total(Due) as Balance
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?