< Sql Tutorial

Sql Having Clause

← Previous Next →


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 

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

Example 

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

← Previous Next →