What are GROUP BY and HAVING used for?

Enhance your skills with the CompTIA Data+ Certification Test. Engage with flashcards, tackle challenging multiple choice questions, complete with hints and explanations. Get yourself exam-ready now!

Multiple Choice

What are GROUP BY and HAVING used for?

Grouping data into summary rows and filtering those groups is what these clauses handle. GROUP BY creates one summary row for each distinct combination of the specified column values, letting you compute aggregates per group. HAVING then filters those groups based on a condition that usually involves an aggregate function like SUM, COUNT, or AVG. For example, you might group sales by department to get total_sales per department, then use HAVING to keep only departments where total_sales exceeds 100,000. This shows the flow: GROUP BY forms the groups, HAVING decides which groups to keep after the aggregation. ORDER BY sorts the results, while WHERE filters rows before grouping, so it wouldn’t apply to the aggregated groups.

Grouping data into summary rows and filtering those groups is what these clauses handle. GROUP BY creates one summary row for each distinct combination of the specified column values, letting you compute aggregates per group. HAVING then filters those groups based on a condition that usually involves an aggregate function like SUM, COUNT, or AVG. For example, you might group sales by department to get total_sales per department, then use HAVING to keep only departments where total_sales exceeds 100,000. This shows the flow: GROUP BY forms the groups, HAVING decides which groups to keep after the aggregation. ORDER BY sorts the results, while WHERE filters rows before grouping, so it wouldn’t apply to the aggregated groups.

More practice questions