Re: Aggregate functions on empty sets in SQL

Mikito,

For better or for worse, the aggregate functions were defined to have no value when aggregating over an
empty set. Hence NULL is the right answer.

One could argue whether the definition is as useful as it might be, but that's a different story.

--
Regards,
    David Cressey
    www.dcressey.com