This is the documentation for CDH 5.1.x. Documentation for other versions is available at Cloudera Documentation.

HAVING Clause

Performs a filter operation on a SELECT query, by examining the results of aggregation functions rather than testing each individual table row. Thus always used in conjunction with a function such as COUNT(), SUM(), AVG(), MIN(), or MAX(), and typically with the GROUP BY clause also.

Page generated September 3, 2015.