Home
Compass SQL Reference
Aggregation functions
SUM
SUM
Use SUM to add numeric values and return a single value.
Syntax
SUM(numeric_expression)
Side TOC
Side TOC
Compass SQL Reference
Query structure
Expressions and comparison functions
Logical and comparison operators
String functions
Mathematical operators
Mathematical functions
Aggregation functions
AVG
COUNT
MAX
MIN
SUM
Datetime functions
Conversion functions
Analytic functions
Views