ReferenceSQL ReferenceAggregate Functions

retention

Takes a list of conditions (from 1 to 32) and, for each row group, returns an array of 0/1 values indicating whether the first condition and each subsequent condition were satisfied.

Takes a list of conditions (from 1 to 32) and, for each row group, returns an array of 0/1 values indicating whether the first condition and each subsequent condition were satisfied.

rankCorr

Computes a rank correlation coefficient.

row_number

Numbers the current row within its partition starting from 1.