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 SUM and AVG ignore NULL values by default. The NVL function converts NULL values to a specified non-null value (like 0), allowing those converted values to be included in aggregate calculations.

Keep practicing — related questions