Group By returns a single value for each value in the column(s) specified in the ____ clause.

Group By returns a single value for each value in the column(s) specified in the ____ clause.

• A. Where
• B. Having
• C. Order By
• D. Group By

Answer: (D)

Grouping rows in SQL creates one result per distinct combination of values in the columns you specify. The Group By clause defines those grouping columns, and for each group you typically compute aggregates (like SUM, COUNT, AVG, MAX, MIN), producing a single value per group. So the statement means you get one row for every distinct group, with the aggregated values representing that group. For example, SELECT department, SUM(sales) FROM sales GROUP BY department returns one row per department with the total sales for that department. The other clauses don’t define groups: WHERE filters which rows to include before grouping, HAVING filters groups after aggregation, and ORDER BY just sorts the final result.

Grouping rows in SQL creates one result per distinct combination of values in the columns you specify. The Group By clause defines those grouping columns, and for each group you typically compute aggregates (like SUM, COUNT, AVG, MAX, MIN), producing a single value per group. So the statement means you get one row for every distinct group, with the aggregated values representing that group.

For example, SELECT department, SUM(sales) FROM sales GROUP BY department returns one row per department with the total sales for that department.

The other clauses don’t define groups: WHERE filters which rows to include before grouping, HAVING filters groups after aggregation, and ORDER BY just sorts the final result.