- 01Getting Started
- 02SELECT Statement Basics
- 03Filtering Rows with WHERE
- 04Sorting Results with ORDER BY
- 05Combining Tables with JOIN
- 06Aggregating Data with GROUP BY
- 07Fuzzy Matching with LIKE
- 08Modifying Data with INSERT, UPDATE, and DELETE
- 09Introduction to Subqueries
- 10Creating a VIEW
- 11Ranking Rows with Window Functions
- 12Understanding Transactions
- 13Writing Comments in SQL
- 14Logical Operators: AND, OR, NOT
- 15Working with NULL Values
- 16INNER JOIN vs. LEFT JOIN
- 17Filtering Aggregates with HAVING
- 18Removing Duplicates with DISTINCT
- 19Combining Results with UNION
- 20Conditional Values with CASE
- 21Checking Existence with EXISTS
- 22Changing Table Structure with ALTER TABLE
- 23Self Joins
- 24Speeding Up Searches with INDEX
- 25GROUP BY with Multiple Columns
- 26Pagination with LIMIT and OFFSET
- 27Pattern Matching with GLOB
- 28Date Calculations with the date() Function
- 29Joining Three Tables
- 30Matching Multiple Values with IN
- 31Derived Tables: Subqueries in FROM
- 32The Basics of TRIGGER
- 33Readable Queries with WITH (CTEs)
- 34UPSERT: Insert or Update in One Statement
- 35Combining MIN, MAX, and AVG
- 36Restricting Input with CHECK Constraints
- 37Auto-Numbering with AUTOINCREMENT
- 38Inspecting Query Plans with EXPLAIN QUERY PLAN
- 39ORDER BY with Multiple Columns
- 40Conditional Aggregation with CASE
- 41Removing Objects with DROP TABLE and DROP VIEW
- 42Combining Multiple CTEs
- 43Date Range Search with BETWEEN
- 44Finding What's Missing with NOT EXISTS
- 45Substituting NULL with COALESCE
- 46String Functions: UPPER, LENGTH, and SUBSTR
- 47Converting Types with CAST
- 48Merging Grouped Values with GROUP_CONCAT
- 49Enforcing Integrity with FOREIGN KEY
- 50Capstone: Build a Mini Library Management System
GROUP BY with Multiple Columns
This lesson covers grouping by multiple columns at once, so you can analyze data at a finer level of detail. It's for anyone searching "SQL GROUP BY multiple columns."
Specifying GROUP BY col1, col2 groups by the combination of both columns — like "per class, and within that, per gender" — giving you a finer-grained breakdown than a single column allows.
The example groups by class_id, gender to count students for every class-and-gender combination. Compare this against grouping by just one column to really see how the number of result rows changes.
A common early mistake is confusing the order of columns in GROUP BY with the order results are displayed in — GROUP BY's column order only determines the grouping level, not the display order; for that you still need a separate ORDER BY. A single-column grouping is often too coarse for a real report, but combining columns gets you the kind of fine-grained breakdown that shows up constantly in sales analysis — and the order you list the columns in changes how the results read.
💡 The SQL engine may take a few seconds to load the first time you run code.