Multiple choice technology databases

Which is the clause used to restrict groups?

  1. HAVING

  2. WHERE

  3. Order By

  4. Group by

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

The HAVING clause filters grouped results after the GROUP BY operation, while WHERE filters individual rows before grouping. HAVING can use aggregate functions like COUNT, SUM, or AVG, which WHERE cannot.