Using the Relational Data Framework › Use Expressions and Functions › Numeric Aggregate Functions › SUM Function

SUM Function

The SUM function returns the sum of all values in a specified column. For example, to obtain the total cost of all workstations in the WORKSTATIONS table, use this statement:

OPSQL SELECT SUM (COST) FROM WORKSTATIONS

This would yield a result of 13,400.

The SUM function is limited to use on numeric data types only. All integer and decimal data types are accepted.