Multiple choice technology

Which of the following denote group clause in SQL

  1. having

  2. group by

  3. Where

  4. Both A. and B.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

GROUP BY and HAVING are both group-related clauses in SQL. GROUP BY aggregates data into groups, while HAVING filters those groups after aggregation. WHERE filters individual rows before grouping, not groups themselves.

Keep practicing — related questions