PLS-00118: Duplicate group-by clause in table expression



PLS-00118: Duplicate group-by clause in table expression..

Answer / guest

Cause: Two or more GROUP BY clauses were found in a SELECT
statement. The GROUP BY clause lists column expressions used
to form a summary row for each group of selected rows. The
list can contain several column expressions separated by
commas, but a statement can contain only one GROUP BY clause.

Action: Remove one of the GROUP BY clauses and, if
necessary, separate column expressions by commas.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24437: OCIStmtExecute called before OCIStmtPrepare2.

1 Answers  


ORA-23323: parameter length exceeds deferred RPC limits

1 Answers  


ORA-32036: unsupported case for inlining of query name in WITH clause

1 Answers  


DGM-16909: Fatal error - quitting...

1 Answers  


ORA-03230: segment only contains string blocks of unused space above high water mark

1 Answers  


ORA-01655: unable to extend cluster string.string by string in tablespace string

1 Answers  


ORA-00091: LARGE_POOL_SIZE must be at least string

1 Answers  


LSX-00162: string "~S" is an invalid default for the complex type

1 Answers  


ORA-24122: invalid block range specification

1 Answers  


ORA-12542: TNS:address already in use

1 Answers  


ORA-31209: DBMS_LDAP: PL/SQL - LDAP count_entry error.

1 Answers  


ORA-07844: sllfop: LIB$GET_VM failure

1 Answers  


Categories