The purpose of the SQL SELECT GROUP BY clause is ____.
A) to present rows of a table with common attribute values together as groups in the query output
B) to present columns of a table with common attribute values together as groups in the query output
C) to group together rows of a table with common attribute values in order to perform calculations using the built-in functions on attributes within each group
D) to group together columns of a table with common attribute values in order to perform calculations using the built-in functions on attributes within each group
E) None of the above.

Question

Quizplus · Accepted Answer

The SELECT GROUP BY clause is used to group together rows of a table with common attribute values in order to perform calculations using the built-in functions on attributes within each group. It allows us to apply aggregate functions (such as SUM, COUNT, AVG, etc.) to each group.

The Purpose of the SQL SELECT GROUP BY Clause Is