HAVING Clause
Specify a condition to filter groups for inclusion in the SELECT results.
The HAVING
clause is used in conjunction with aggregate functions and the GROUP BY
clause to control which groups are selected. A HAVING
clause eliminates groups that do not satisfy the given conditions. HAVING
filters groups after groups and aggregates are computed.
Example
SELECT sum(sent_bytes) as total_sent, client_ip
FROM "sample-elb-view"
GROUP BY "client_ip"
HAVING sum("sent_bytes") > '90000'
ORDER BY "total_sent" DESC LIMIT 25;
Updated 7 months ago