Aggregate Functions and Null Values

Aggregate functions calculate the summary values of the non-null values in a particular column.

If the ansinull option is set off (the default), there is no warning when an aggregate function encounters a null. If ansinull is set on, a query returns the following SQLSTATE warning when an aggregate function encounters a null:
Warning- null value eliminated in set function