Oracle having, oraclehaving

Oracle having, oraclehaving

The HAVING clause is added to SQL because the WHERE keyword cannot be used with the aggregate function.

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

Example 1: Find customers with a total order amount less than 2000

SELECT Customer, SUM (OrderPrice) FROM Orders
Group by Customer
Having sum (OrderPrice) <2000;

Example 2: Find the customer "Bush" or "Adams" with more than 1500 of the total order amount

SELECT Customer, SUM (OrderPrice) FROM Orders
WHERE Customer = 'Bush 'OR Customer = 'adams'
Group by Customer
Having sum (OrderPrice)> 1500;