[Solved] What does the GROUP BY clause do in an SQL query? — Ans: It groups rows that have the same values in a specified column. | SQL

SQL - GROUP BY and HAVING

What does the GROUP BY clause do in an SQL query?

AIt deletes duplicate rows from the table.

BIt sorts the rows in ascending order.

CIt groups rows that have the same values in a specified column.

DIt filters rows based on a condition.

Step-by-Step Solution

Solution:

Step 1: Understand the purpose of GROUP BY
The GROUP BY clause collects rows with the same value in the specified column into groups.
Step 2: Differentiate from other clauses
Unlike ORDER BY which sorts, or WHERE which filters, GROUP BY organizes data for aggregation.
Final Answer:
It groups rows that have the same values in a specified column. -> Option C
Quick Check:
GROUP BY = grouping rows by column [OK]

Quick Trick: GROUP BY collects rows sharing column values [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What does the GROUP BY clause do in an SQL query?