5.2

Grouping Data

Using the GROUP BY Clause

Table 1. GROUP BY Function

Aggregate Function

Order of Execution

Description

GROUP BY

3

Groups rows of a result set based on columns or expressions separated by commas.

Filtering With WHERE And HAVING

CC BY-NC-ND International 4.0

CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.