How to fix the Oracle error QSM-02143: SUM(expr) without COUNT(expr)?

AbundantCode 4 weeks ago in Oracle 0

In this post, you’ll learn more about the Oracle ErrorQSM-02143: SUM(expr) without COUNT(expr) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error QSM-02143: SUM(expr) without COUNT(expr)

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

How to fix the Error QSM-02143: SUM(expr) without COUNT(expr) ?

You can fix this error in Oracle by following the below steps

Add COUNT(expr) to the select list.

Tags :

Leave Your Comment