Skip to Content

mvSQL Database Function - SUM()

Summary

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

Syntax

SUM(<column>)

Parameters

column

The column to sum.

Remarks

SUM can be used with numeric columns only. Null values are ignored.

Returns

The sum of all values.

Examples

SUM(MonthlyExpenditures)

Returns

108.65