What is the result of `AVG(col)` when all values in col are NULL?

Advanced SQL Developer Easy

Advanced SQL Developer — Easy

What is the result of `AVG(col)` when all values in col are NULL?

Key points

  • NULL values are not included in the average calculation.
  • The AVG function treats NULL values as non-existent.
  • The result of AVG with all NULL values is NULL.

Ready to go further?

Start full exam Practice more questions

Related questions