Receive all updates via Facebook. Just Click the Like Button Below

Blogger Widgets
/

Watch Intro About My Website ! ! !

Wednesday, 6 November 2013


The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.

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


We have the following "Orders" table:

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

Tagged:

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...