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