Subject Re: [firebird-support] Re: Coalesce Help in Stored Procedure
Author Dimitry Sibiryakov
On 23 Aug 2004 at 17:40, Muthu Annamalai wrote:

>I still don't understand, I think I can catch after a while working
>with coalesce.

It has nothing with COALESCE. It is basing SQL rules. Aggregate
queries (with SUM(), COUNT(), AVG() and so on) _always_ return one
(and without GROUP BY - only one) record.

SY, Dimitry Sibiryakov.