HAVING Clause

                                                    HAVING Clause

having clause is used with SQL Queries to give more precise condition for a statement. It is used to mention condition in Group based SQL functions, just like WHERE clause.

Syntax for having will be,

select column_name, function(column_name)
FROM table_name
WHERE column_name condition
GROUP BY column_name
HAVING function(column_name) condition
Example of HAVING Statement

Consider the following Sale table.

oid order_name previous_balance customer
11 ord1 2000 Alex
12 ord2 1000 Adam
13 ord3 2000 Abhi
14 ord4 1000 Adam
15 ord5 2000 Alex
Suppose we want to find the customer whose previous_balance sum is more than 3000.

We will use the below SQL query,

SELECT *from sale group customer
having sum(previous_balance) > 3000
Result will be,

oid order_name previous_balance customer
11 ord1 2000 Alex