QSM-02144: aggregate functions are present without a GROUP
BY clause



QSM-02144: aggregate functions are present without a GROUP BY clause..

Answer / guest

Cause: One or more aggregate functions are present in the
select list but a GROUP BY clause is not used.

Action: Add a GROUP BY clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph

1 Answers  


ORA-29389: too many errors during validation

1 Answers  


ORA-25207: enqueue failed, queue string.string is disabled from enqueueing

1 Answers  


ORA-02148: EXCLUSIVE specified multiple times

1 Answers  






ORA-25305: enqueue failed, expiration must be zero for queue string.string

1 Answers  


RMAN-06515: archived logs required to recover from this copy will expire when this copy expires

1 Answers  


ORA-15073: diskgroup string is mounted by another ASM instance

1 Answers  


PCC-00100: Non integer label is not ANSI

1 Answers  


NNF-04004: Invalid string in inputfile

1 Answers  


LFI-00114: Append is not allowed with string.

1 Answers  


ORA-31652: command response message was invalid type - detaching job

1 Answers  


Categories