anyLast

Introduced in: v1.1.0

Selects the last encountered value of a column.

By default, the function never returns NULL, i.e. ignores NULL values in the input column. However, if the function is used with the RESPECT NULLS modifier, it returns the last value reads no matter if NULL or not.

Syntax

anyLast(column) [RESPECT NULLS]

Aliases: last_value

Arguments

column — The column name. Any

Returned value

Returns the last value encountered. Any

Examples

Usage example

CREATE TABLE tab(city Nullable(String)) ENGINE=Memory;
INSERT INTO tab (city) VALUES ('Amsterdam'), (NULL), ('New York'), ('Tokyo'), ('Valencia'), (NULL);
SELECT anyLast(city), anyLastRespectNulls(city) FROM tab;

┌─anyLast(city)─┬─anyLastRespectNulls(city)─┐
│ Valencia      │ ᴺᵁᴸᴸ                      │
└───────────────┴───────────────────────────┘