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 is used to filter groups after aggregation, similar to how WHERE filters individual rows before aggregation. You cannot use WHERE with aggregate functions - HAVING is the correct clause for restricting groups based on aggregate conditions.

Keep practicing — related questions