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

Question Posted / guest

1 Answers
3316 Views
I also Faced
E-Mail Answers

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

NPL-00310: ASN.1 sequence has already been ended on read

1 Answers

ORA-23373: object group "string"."string" does not exist

1 Answers

NNO-00318: overriding next statistic counter reset, resetting in number seconds

1 Answers

ORA-01183: cannot mount database in SHARED mode

1 Answers

TNS-00310: Navigator: Failed to start tracing after rereading parameter data

1 Answers

DRG-50950: circular SQE found

1 Answers

LSX-00175: a complex base within "simpleContent" must have simple content

1 Answers

PCC-02331: undefined SQL identifier

1 Answers

ORA-02734: osnftt: cannot reset shared memory permission

1 Answers

ORA-38758: cannot flashback data file string; restored since last recovery

1 Answers

PLS-01505: ALTER is non-ANSI

1 Answers

ORA-02729: osncon: driver not in osntab

1 Answers

For more Oracle Errors Interview Questions Click Here