you are at Encyclopedia of SQL >> HAVING
HAVING
To limit result of query by specific condition there can be used HAVING.
It is similar to WHERE but opposed to HAVING it can be used with aggregation
functions.
Syntax
SELECT `column_name1`,SUM(`column_name2`)
FROM `table_name`
GROUP BY `column_name1`
HAVING aggregation_function operator 'value'
Example
Display name and surname of people who placed orders for value > 200
| 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`
HAVING SUM(`orders`)>200
result
| name | surname | SUM(`orders`) |
|---|
| Franciszek | Nowak | 300 |
| Jan | Kowalski | 270 |
[ wróć na górę strony ]
