Function
specifies the characteristics of a group.
Format
<having clause> ::=
HAVING <search condition>
Syntax Rules
none
General Rules
1. Each <expression> that is not specified in the argument of a <set function spec> but occurs in the <search condition> must denote a grouping column.
2. The <search condition> is applied to each group of the result table. The result of the <having clause> is a table that only contains those groups for which the <search condition> is satisfied.