SQL HAVING

The SQL HAVING clause is similar to SQL WHERE clause. The difference is that the SQL HAVING clause is used in aggregate functions but the SQL WHERE clause cannot be used in aggregate functions.

SQL HAVING clause Syntax

SELECT ColumnName1, ColumnName2, Aggregate_function (ColumnName)
FROM TableName
WHERE conditions
GROUP BY ColumnName1, ColumnName2
HAVING Aggregate_function (ColumnName) operator value

Note: The Aggregate_function could be SQL MAX, MIN, SUM, COUNT or AVG.

SQL HAVING Clause Example

Table: Employees

Example 1
Select departments which has more than 3 employees:

SELECT Department, COUNT(EmployeeId)
FROM Employees
GROUP BY Department
HAVING COUNT(EmployeeId)>3

The result will look like:

Example 2
Select departments whose minimum salary is more than $46,000:

SELECT Department, MIN(Salary)
FROM Employees
GROUP BY Department
HAVING MIN(Salary)>46000

The result will look like: