SQL HAVING

By /

The SQL HAVING Clause
The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.

HAVING Syntax
SELECT column_name(s)
FROM table_name
WHERE condition
GROUP BY column_name(s)
HAVING condition
ORDER BY column_name(s);

Example
SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country HAVING COUNT(CustomerID) > 5;

Scroll to Top