Cheat Sheet logoCheat Sheet Today
SQL Cheat Sheet/Group by multiple columns

Aggregate by more than one dimension.

Back to sheetBrowse commands
Sign in to save
Section: Aggregation and Grouping

Group by multiple columns

sql
sql
SELECT country, status, COUNT(*) AS total
FROM customers
GROUP BY country, status;
Explanation

Useful for reports sliced by multiple categories.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Aggregation and Grouping
Group by a column
Aggregate values per group.
OpenIn sheetsqlsame section
Filter groups with HAVING
Apply conditions after aggregation.
OpenIn sheetsqlsame section
Count rows
Return total row count.
OpenIn sheetsqlsame section
Use common aggregate functions
Calculate summary metrics.
OpenIn sheetsqlsame section
Select all columns
Return all columns from a table.
OpenIn sheetsql
Filter with equality
Return rows matching an exact value.
OpenIn sheetsql