Database Error Messages

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

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