Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-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.