Database Error Messages

OCI-62242

HAVING clause can only contain AND predicates when approximate top functions are used.

Cause

the HAVING clause contained predicates other than AND when approximate top functions were used.


Action

Only use the AND predicate with the HAVING clause.