Question

How are NULL values treated by aggregate functions ?

Answer 1

Hi, This is your answer

According to the SQL Reference Manual section on Aggregate Functions: All aggregate functions except COUNT(*) and GROUPING ignore nulls. You can use the NVL function in the argument to an aggregate function to substitute a value for a null. COUNT never returns null, but returns either a number or zero.

Hope you like my answer ☺☺