CBSE Class 12 Computer Science Question 39 of 91

Grouping Records, Joins in SQL — Question 17

Back to all questions
17
Question

Question 17

Which clause cannot be used with "aggregate functions" ?

  1. GROUP BY
  2. SELECT
  3. WHERE
  4. Both (1) and (3)
Answer

WHERE

Reason — Aggregate functions cannot be used with the WHERE clause in SQL because the WHERE clause filters rows before any grouping or aggregation occurs.