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-06748: TLI Driver: cannot allocate t_discon

1 Answers  


ORA-07267: spwat: invalid process number.

1 Answers  


NNO-00800: Error: cannot read version from config database

1 Answers  


ORA-27068: I/O buffer is not aligned properly

1 Answers  


DGM-16906: Unable to accept commands: no memory

1 Answers  






ORA-13709: Required parameter "string" must be set before execution.

1 Answers  


PLS-00325: non-integral numeric literal string is inappropriate in this context

1 Answers  


NNL-00216: Disabled auto-refresh for specified index number

1 Answers  


ORA-24460: Native Net Internal Error

1 Answers  


DRG-10750: unknown parameter string

1 Answers  


SQL*Loader-00969: Error performing file name translation on kernel side

1 Answers  


ORA-23464: flavor lacks column string of "string"."string"

1 Answers  


Categories