Database Error Messages

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

ORA-62235

PARTITION BY key in APPROX_RANK is not a subset of GROUP BY key.

Cause

The PARTITION BY key in the APPROX_RANK function was not a subset of the key in the GROUP BY clause.


Action

Use a subset of the key in the GROUP BY clause in the PARTITION BY key within the APPROX_RANK function.