Home
Compass SQL Reference
Analytic functions
Analytic functions
This section describes the analytic functions that are supported.
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
Datetime functions
Conversion functions
Analytic functions
LEAD
RANK …OVER … PARTITION BY
ROW_NUMBER … OVER … PARTITION BY
Views