Quadcap Software

Quadcap Embeddable Database

Quadcap Software

HAVING clause

The HAVING clause is used as a predicate to select rows after the grouping operation specified by the GROUP BY clause.

In particular, the HAVING clause is used to test the result of applying aggregate functions, since these functions can't be evaluated in the WHERE clause.

Syntax

selectHaving
  :  (  "having" expression 
    |  
    ) 
  ;