Aggregate Functions

Aggregate functions operate on a set of values to compute a single result.

General Aggregate Functions

last(x) x

Returns the last value of x for a group of rows.

last(x, ignoreNull) x

Returns the last value of x for a group of rows. If ignoreNull is true, returns only non-null values.