| Subject | Re: SUM function returns NULL if no Records, Need it to return 0 |
|---|---|
| Author | zaher dirkey |
| Post date | 2006-08-07T00:26:18Z |
--- In firebird-support@yahoogroups.com, Robert martin <rob@...> wrote:
HAVING
COALESCE(SUM(Amount), 0) > 0
>I prefer
> HAVING
> SUM(COALESCE(Amount, 0)) > 0
>
>
HAVING
COALESCE(SUM(Amount), 0) > 0