Database Utilities
ContentsOpens a new window
Opens a new window
Page 694 of 1018

SUM

Returns the sum of values of an expression.

Syntax

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.

Previous PageOpens a new window
Page 694 of 1018
Next PageOpens a new window