ORA-62240
Missing one or more corresponding APPROX_RANK clause in HAVING list when approximate top functions are used.
Cause
One or more corresponding APPROX_RANK clauses were missing when approximate top functions were used.
Action
Add the APPROX_RANK clause in HAVING list for each approximate top N function that appears in SELECT or ORDER BY clause
ORA-62240
Missing one or more corresponding APPROX_RANK clause in HAVING list when approximate top functions are used.
Cause
One or more corresponding APPROX_RANK clauses were missing when approximate top functions were used.
Action
Add the APPROX_RANK clause in HAVING list for each approximate top N function that appears in SELECT or ORDER BY clause
ORA-62240
Missing one or more corresponding APPROX_RANK clause in HAVING list when approximate top functions are used.
Cause
One or more corresponding APPROX_RANK clauses were missing when approximate top functions were used.
Action
Add the APPROX_RANK clause in HAVING list for each approximate top N function that appears in SELECT or ORDER BY clause