Home
Compass SQL Reference
Aggregation functions
AVG
AVG
Use AVG to average the results of numeric values in a result.
Syntax
AVG(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