mvSQL Database Function - SUM()¶

Summary¶

Returns the sum of all the values, or only the DISTINCT values, in the expression.

Syntax¶

SUM(<column>)

SUM(DISTINCT <column>)

Parameters¶

column¶

The column to sum.

Remarks¶

SUM can be used with numeric columns only. Null values are ignored. With the optional DISTINCT modifier, only unique values are summed.

Returns¶

The sum of all values.

Examples¶

SUM(MonthlyExpenditures)

Returns

108.65