The GROUP BY Clause
The GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. The GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause.
The position of the GROUP BY clause in a query is as follows:
SELECT FROM WHERE GROUP BY ORDER BY
The GROUP BY clause must follow the conditions in the WHERE clause and must precede the ORDER BY clause if one is used.
The following is the SELECT statement's syntax, including the GROUP BY clause:
SELECT COLUMN1, COLUMN2 FROM TABLE1, TABLE2 WHERE CONDITIONS GROUP BY COLUMN1, COLUMN2 ORDER BY COLUMN1, COLUMN2
The following sections give examples and explanations of the GROUP BY clause's use in a variety of situations ...