Multiple choice technology databases

Which function forces group functions to include null values?

  1. Group By

  2. NVL

  3. Order By

  4. Having
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Aggregate functions like COUNT, SUM, AVG ignore NULL values by default. The NVL function converts NULL values to a specified value, effectively forcing them to be included in the aggregation. GROUP BY, ORDER BY, and HAVING are clauses, not functions for handling NULL values.

Keep practicing — related questions