Courses / SQL
7. GROUP BY clause
A clause that groups rows sharing a property so aggregate functions can be applied.
1 min read Chapter 7 of 29
SQL
GROUP BY clause
The GROUP BY clause is used to group rows that share a common property in SQL.
"I want to summarize my sales data without manually sorting through each entry."
The GROUP BY clause groups rows that have the same values in specified columns into summary rows, allowing aggregate functions like COUNT or SUM to be applied to each group.
"I want to summarize my sales data without manually sorting through each entry."
The GROUP BY clause groups rows that have the same values in specified columns into summary rows, allowing aggregate functions like COUNT or SUM to be applied to each group.