Group By
Written By Bear
The GROUP BY clause groups records into summary row(s). GROUP BY returns one records for each group.
The GROUP BY statement is often used to return a result-set with aggregate functions (COUNT, MAX, MIN, SUM, AVG) for one or more columns.
SQL GROUP BY Syntax:
SELECT Column1, Column2, Column3
FROM Table_Name
GROUP BY Column1
Example:
Lets use the “Products” table to count the number of products for each supplier.
| ProductID | ProductName | Description | Price | SupplierName | SupplierID |
|---|---|---|---|---|---|
| 1 | Super Printer | 9000 series printer | 300 | TechOne | 1 |
| 2 | Laptop 5 | 4000 Laptop 5th generation | 700 | TechTwo | 2 |
| 3 | 3D Printer | 3D Print Pro | 900 | TechOne | 1 |
| 4 | Labtop 7 | 100 Labtop 7 processor | 1200 | TechTwo | 2 |
| 5 | Camera 400 | Camera Ultra 400 | 400 | TechThree | 3 |
SELECT
Count (SupplierName) as Count,
SupplierName
FROM Products
GROUP BY SupplierName
Results:
| Count | SupplierName |
|---|---|
| 2 | TechOne |
| 2 | TechTwo |
| 1 | TechThree |
Get a free SQL Code Reference Here
SQL Tutorial