SQL GROUP BY Statement
The SQL GROUP BY Statement
The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.
GROUP BY Syntax
Demo Database
Below is a selection from the "Customers" table in the Northwind sample database:
SQL GROUP BY Examples
The following SQL statement lists the number of customers in each country
The following SQL statement lists the number of customers in each country, sorted high to low:
Demo Database
Below is a selection from the "Orders" table in the Northwind sample database
And a selection from the "Shippers" table:
GROUP BY With JOIN Example
The following SQL statement lists the number of orders sent by each shipper:
Last updated