Multiple choice technology programming languages

Which function forces group functions to include null values?

  1. Group By

  2. NVL

  3. Order By

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

Group functions (like SUM, AVG, COUNT) ignore null values by default. The NVL function converts null values to a specific default value (such as 0 or a placeholder) before the group function is applied, forcing group functions to include those records. Group By and Order By are syntax clauses, and 'Include NULL' is not a standard SQL function.

Keep practicing — related questions