SQL HAVING Syntax
SELECT column_name,
aggregate_function(column_name)
FROM table_name WHERE column_name operator value GROUP BY column_name HAVING aggregate_function(column_name) operator value |
SQL HAVING Example
Id
|
OrderDate
|
OrderPrice
|
Customer
|
1
|
2008/11/12
|
1000
|
Navis
|
2
|
2008/10/23
|
1600
|
Nilsen
|
3
|
2008/09/02
|
700
|
Navis
|
4
|
2008/09/03
|
300
|
Navis
|
5
|
2008/08/30
|
2000
|
Jensen
|
6
|
2008/10/04
|
100
|
Nilsen
|
Now we want to find if any of the customers have a total order of less than 2000.
We use the following SQL statement:
SELECT Customer,SUM(OrderPrice) FROM
Orders
GROUP BY Customer HAVING SUM(OrderPrice)<2000 |
The result-set will look like this:
Customer
|
SUM(OrderPrice)
|
Nilsen
|
1700
|
0 comments:
Post a Comment