SUM

Returns the sum of values of an expression.

Syntax

See Oracle Database SQL Language Reference.

Restrictions

The following restrictions apply when you use the SUM function in the SELECT command:

• The expression must be a numeric column or a numeric constant.

• The function does not support the DISTINCT or ALL keywords.

• The function does not support the OVER clause.