Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 32 of 90

Querying Using SQL — Question 10

Back to all questions
10
Question

Question 10

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.