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 ]