| Subject | Re: [firebird-support] Re: How write a query with a progressive sum field |
|---|---|
| Author | Luigi Siciliano |
| Post date | 2016-03-08T11:21:13Z |
Hallo,
Il 08/03/2016 11.24, Aage Johansen
aagjohan@... [firebird-support] ha scritto:
In this case I obtain that the SALDO field reports 0 instead of null.
You could try
coalesce(sum(DC2.CARICO-DC2.SCARICO),0) as SALDO
Thanks.
--
Luigi Siciliano --------------------------