Aggregate and approximate functions

Preview BigQuery aggregate and window functions in BigQuery compatibility mode, by BigQuery category.

​

Aggregate functions

BigQuery reference: Aggregate functions. An aggregate call may use FILTER (WHERE ...), an in-argument ORDER BY, a HAVING MAX/HAVING MIN modifier, or an OVER (...) window with ROWS and RANGE frames.

​

Approximate aggregate functions

BigQuery reference: Approximate aggregate functions.

​

Statistical aggregate functions

BigQuery reference: Statistical aggregate functions. Inputs are evaluated as double precision.

​

HyperLogLog++ functions

BigQuery reference: HyperLogLog++ functions.

​

Numbering functions

BigQuery reference: Numbering functions.

​

Navigation functions

BigQuery reference: Navigation functions.