Oracle Error ORA-30489: Cannot have more than one rollup/cube expression list

Oracle Error Message

ORA-30489: Cannot have more than one rollup/cube expression list

Reason for the Error

GROUP BY clause has more than one rollup/cube expression list.

Solution

Modify the query such that only one rollup/cube expressions appear per sub-query.