Using the HAVING Clause to Filter Groups of Rows : HAVING « Query Select « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Query Select
3. HAVING

You use the HAVING clause to filter groups of rows.

GROUP BY can be used without HAVING.

But HAVING must be used in conjunction with GROUP BY.

You place the HAVING clause after your GROUP BY clause:

SELECT ...
FROM ...
WHERE
GROUP BY ...
HAVING ...
ORDER BY ...;