any_not_null

any_not_null(expression: storable) -> expression

Return any non-null value of one column across a group. Can still return null if all values in the group are null

Domain

This is an aggregate function (aggregates rows over a group in aggregate verbs).

This is a window function (calculates over a group of multiple input rows using windowing).

Categories