HAVING Clause

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;