Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 33 of 91

Grouping Records, Joins in SQL — Question 11

Back to all questions
11
Question

Question 11

All aggregate functions except ............... ignore null values in their input collection.

  1. Count(attribute)
  2. Count(*)
  3. Avg
  4. Sum
Answer

Count(*)

Reason — All aggregate functions, except for COUNT(*), ignore null values in their input collection. COUNT(*) returns all rows, including duplicates and nulls.