Relational Data - Aggregate Functions - Reference - Anylast
Selects the last value encountered, ignoring any NULL
values by default. The result is just as indeterminate as for the any function.
Syntax
anyLast(column) [RESPECT NULLS]
Parameters - column
: The column name.
Supports the RESPECT NULLS
modifier after the function name. Using this modifier will ensure the function selects the first value passed, regardless of whether it is NULL
or not.
Returned value
- The last value encountered.
Example
Query:
CREATE TABLE any_last_nulls (city Nullable(String)) ENGINE=Log;
INSERT INTO any_last_nulls (city) VALUES ('Amsterdam'),(NULL),('New York'),('Tokyo'),('Valencia'),(NULL);
SELECT anyLast(city) FROM any_last_nulls;
┌─anyLast(city)─┐ │ Valencia │ └───────────────┘