Subject | Re: [firebird-support] How write a query with a progressive sum field |
---|---|
Author | Luigi Siciliano |
Post date | 2016-03-07T10:51:29Z |
Hallo,
Il 07/03/2016 11.32, Dimitry Sibiryakov sd@...
[firebird-support] ha scritto:
not a field of my table.
I badly explained myself: I have a table with only this fields:
DATA DOCUMENTO_ID NUMERO SERIE CARICO SCARICO
I need add SALDO fields in the result of the query to get a progressive
sum of CARICO - SCARICO.
Thanks
--
Luigi Siciliano
--------------------------
Il 07/03/2016 11.32, Dimitry Sibiryakov sd@...
[firebird-support] ha scritto:
> sum(saldo) over (order by data)Thank You for your response but I can't do: sum(SALDO) because SALDO is
not a field of my table.
I badly explained myself: I have a table with only this fields:
DATA DOCUMENTO_ID NUMERO SERIE CARICO SCARICO
I need add SALDO fields in the result of the query to get a progressive
sum of CARICO - SCARICO.
Thanks
--
Luigi Siciliano
--------------------------