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

HAVING filters groups after aggregation, while WHERE filters individual rows before aggregation. You cannot use aggregate functions in WHERE, but you can in HAVING.