Multiple choice technology databases

Which clause should you use to exclude group results?

  1. WHERE

  2. HAVING

  3. RESTRICT

  4. GROUP BY

  5. ORDER BY
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

HAVING is used to filter grouped results after aggregation, unlike WHERE which filters rows before grouping. HAVING is essential when you need to apply conditions to aggregate functions like COUNT, SUM, or AVG.

Keep practicing — related questions