HAVING Clause
Performs a filter operation on a SELECT
query, by examining the results of aggregation
functions rather than testing each individual table row. Therefore, it is always used in conjunction with a
function such as COUNT()
,
SUM()
,
AVG()
,
MIN()
, or
MAX()
, and typically with the
GROUP BY
clause also.
Restrictions:
The filter expression in the HAVING
clause cannot include a scalar subquery.
Related information:
SELECT Statement, GROUP BY Clause, Impala Aggregate Functions