{"id":130422,"date":"2022-04-13T17:59:59","date_gmt":"2022-04-13T21:59:59","guid":{"rendered":"https:\/\/brainstation.io\/?post_type=codex-reference&p=130422"},"modified":"2025-02-04T14:40:55","modified_gmt":"2025-02-04T19:40:55","slug":"group-by","status":"publish","type":"codex-reference","link":"https:\/\/brainstation.io\/learn\/sql\/group-by","title":{"rendered":"Group By"},"content":{"rendered":"\n
<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>

SQL tutorial<\/p><\/div>

SQL Group By<\/h1>

Learn more about SQL, a standard language for interacting with databases and storing, manipulating, and retrieving data from databases.

Go hands-on with SQL in our free interactive SQL tutorial.<\/a><\/p><\/div>

<\/div><\/div><\/div><\/header>\n\n\n\n
\n
\n

While WHERE<\/code> is one of the most useful and frequently used clauses in SQL as it can be applied to filter data, the SQL GROUP BY<\/code> clause is the basis for performing aggregation, unlocking the power of data analytics in SQL.<\/p>\n\n\n\n

The SQL GROUP BY<\/code> clause modifies the behavior of a SELECT<\/code> statement and aggregates data over the column or columns specified. This results in the data being returned in a summarized form, and having equal to or less than the number of rows from the source.<\/p>\n\n\n\n

In a simple query, the GROUP BY<\/code> clause follows the table name, with the column values to aggregate over afterward:<\/p>\n\n\n\n

Code Example<\/span>