Specify a condition to filter groups for inclusion in the SELECT results.
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.
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 6 months ago