SQL
`GROUP BY` and `HAVING` Clauses
<div id="rrdiagram6"></div>  
[The `GROUP BY` clause](#docs:sql:query_syntax:groupby) specifies which grouping columns should be used to perform any aggregations in the `SELECT` clause. If the `GROUP BY` clause is specified, the query is always an aggregate query, even if no aggregations are present in the `SELECT` clause.