CBSE Class 12 Informatics Practices Question 38 of 81

MySQL Functions — Question 20

Back to all questions
20
Question

Question 20

Which of the following are correct aggregate functions in SQL ?

  1. AVERAGE()
  2. MAX()
  3. COUNT()
  4. TOTAL()
Answer

MAX(), COUNT()

Reason — Aggregate functions in SQL include AVG(), COUNT(), MAX(), MIN(), and SUM().