QSM-02145: GROUP BY clause is present but no aggregate
functions are used



QSM-02145: GROUP BY clause is present but no aggregate functions are used..

Answer / guest

Cause: A GROUP BY clause is used but no aggregate functions
are present in the select list.

Action: Add an aggregate function to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16017: cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination

1 Answers  


ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.

1 Answers  


ORA-24311: memory initialization failed

1 Answers  


PCC-02361: Use of ARRAYLEN with SQL bind arrays is ignored

1 Answers  


ORA-26080: file "string" is not part of table string.string partition string

1 Answers  






ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = string

1 Answers  


DRG-11616: URL store: too many redirections trying to access string

1 Answers  


ORA-12571: TNS:packet writer failure

1 Answers  


SQL*Loader-00133: Can't specify both direct path and external tables

1 Answers  


O2U-00204: Unable to convert from the database character set to the compiler character set

1 Answers  


LPX-00254: invalid XML declaration

1 Answers  


SQL*Loader-00930: Error parsing insert statement for table string column string.

1 Answers  


Categories