The SQL SELECT GROUP BY clause is designed to ____.
A) group together the rows of a table that have a common attribute value
B) group together the columns of a table that have a common attribute value
C) group together the attributes of a table that have a common domain of values
D) group together the attributes of a group of tables that have a common domain of values
E) None of the above.

Question

Quizplus · Accepted Answer

The SELECT GROUP BY clause is used to group together the rows of a table that have a common attribute value. This allows for aggregations to be performed on the grouped rows, such as calculating the average or sum of a specific attribute within each group.

The SQL SELECT GROUP BY Clause Is Designed to ____