Multiple choice technology databases

NULL values are ingnored for all SQL: 2008 aggregate functions.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL:2008 and most SQL standards, NULL values are ignored by all aggregate functions like COUNT, SUM, AVG, MIN, MAX, etc. COUNT(*) counts all rows including NULLs, but COUNT(column) ignores NULLs. This behavior ensures aggregate calculations don't get skewed by unknown/missing values.