Database Error Messages

OCI-62239

More than one expression appears in GROUP BY clause but not in PARTITION BY clause.

Cause

An attempt was made to involve more than one columns as the top N key.


Action

Remove the extra expression(s) from GROUP BY clause, or add extra expression(s) to PARTITION BY part in HAVING clause