Computer Science for IGCSE & O level - Databases (Section 6 - No. 7)

What is the purpose of the `GROUP BY` clause in SQL?
To filter the data based on conditions.
To sort the data in ascending order.
To combine rows with the same values in a specified column into a summary row.
To specify the table from which to retrieve data.

Explanation

The `GROUP BY` clause is used to group rows that have the same values in specified columns.

Comments (0)

Advertisement