last
aggregate function (Databricks SQL)
Returns the last value of expr
for the group of rows.
Arguments
expr
: An expression of any type.ignoreNull
: A optional BOOLEAN literalcond
: An optional boolean expression filtering the rows used for aggregation.
Returns
The result type matches expr
.
If ignoreNull
is true the function returns only non-null values unless the entire group of values is NULL.
The default for ignoreNull
is false.
The function is a synonym for last_value aggregate function (Databricks SQL).
This function is non-deterministic.