you are at Encyclopedia of SQL >> GROUPBY
GROUP BY
GROUP BY can group result of query by specific column ( columns ). It is often
used together with aggregation functions.
Syntax
SELECT `column_name`, aggregation_function(`column_name`)
FROM `table_name`
WHERE `column_name` operator 'value'
GROUP BY `column_name`
Example
Display order value for each customer
| id | name | surname | order_value |
|---|
| 1 | Jan | Kowalski | 120 |
| 2 | Franciszek | Nowak | 300 |
| 3 | Michał | Nowak | 200 |
| 4 | Jan | Kowalski | 150 |
query
SELECT `name`,`surname`,sum(`order_value`)
FROM `orders`
GROUP BY `name`,`surname`
result
| name | surname | order_value |
|---|
| Jan | Kowalski | 270 |
| Franciszek | Nowak | 300 |
| Michał | Nowak | 200 |
[ wróć na górę strony ]
