QSM-02143: SUM(expr) without COUNT(expr)



QSM-02143: SUM(expr) without COUNT(expr)..

Answer / guest

Cause: SUM(expr) occurs in the select list without a
corresponding COUNT(expr).

Action: Add COUNT(expr) 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-21300: objects option not installed

1 Answers  


ORA-23532: tables with different synchronization mechanisms are in the same group

1 Answers  


ORA-26691: operation not supported at non-Oracle system

1 Answers  


RMAN-06589: cannot specify DB_FILE_NAME_CONVERT option without AS COPY

1 Answers  


ORA-07211: slgcs: gettimeofday error, unable to get wall clock.

1 Answers  






ORA-00444: background process "string" failed while starting

1 Answers  


ORA-31408: invalid value specified for begin_scn or end_scn

1 Answers  


TNS-01058: Arguments : string

1 Answers  


QSM-02099: mv references a remote table or view in the FROM list

1 Answers  


ORA-34183: (MXCHGDCL22) Partition number already exists.

1 Answers  


SQL*Loader-00430: NULL nested table element is not allowed

1 Answers  


ORA-13002: specified level is out of range

1 Answers  


Categories