Database Error Messages

ORA-62243

Each predicate in HAVING clause must be in the format of 'APPROX_RANK(PARTITION BY ... ORDER BY ... DESC) <(=) n' when approximate top functions are used.

Cause

Illegal predicates were used in the HAVING clause when approximate top functions were used.


Action

Correct the format to 'APPROX_RANK (PARTITION BY ? ORDER BY ? DESC) <(=) n'.