SQL HAVING

HAVING clause is used to specify some condition along with aggregate functions.

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:SELECT emp_id,SUM(salary) FROM employee
WHERE employee_name='tom�
GROUP BY emp_id
HAVING SUM(salary)>1500

---