Database Error Messages

OCI-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