last
aggregate function
Applies to: Databricks SQL Databricks Runtime
Returns the last value of expr
for the group of rows. The function is a synonym for last_value aggregate function.
Syntax
last(expr [, ignoreNull] ) [FILTER ( WHERE cond ) ] [ IGNORE NULLS | RESPECT NULLS ]
This function can also be invoked as a window function using the OVER
clause.
Arguments
expr
: An expression of any type.ignoreNull
: An optional BOOLEAN literal defaulting to false.cond
: An optional boolean expression filtering the rows used for aggregation.IGNORE NULLS
orRESPECT NULLS
: WhenIGNORE NULLS
is used orignoreNull
istrue
anyexpr
value that is NULL is ignored. The default isRESPECT NULLS
.
Returns
The result type matches expr
.
This function is non-deterministic.
Examples
> SELECT last(col) FROM VALUES (10), (5), (20) AS tab(col);
20
> SELECT last(col) FROM VALUES (10), (5), (NULL) AS tab(col);
NULL
> SELECT last(col, true) FROM VALUES (10), (5), (NULL) AS tab(col);
5