REFERENCE
Additional Aggregate Functions
A list of available functions to perform aggregate calculations
Functions
Section titled “Functions”first_value(arg:)
Section titled “first_value(arg:)”Returns the first value (null or non-null) from arg. This function is affected by ordering.
first_value(arg: ANY) -> ANYlast_value(arg:)
Section titled “last_value(arg:)”Returns the last value (null or non-null) from arg. This function is affected by ordering.
last_value(arg: ANY) -> ANYarbitrary(arg:)
Section titled “arbitrary(arg:)”Returns an arbitrary value (NULL or non-NULL) from arg. This function is affected by ordering.
arbitrary(arg: ANY) -> ANYany_value(arg:)
Section titled “any_value(arg:)”Returns the first non-null value from arg. This function is affected by ordering.
any_value(arg: ANY) -> ANY