Functions/Aggregates/last_value
Aggregates Aggregate

last_value()

Arguments & returns

last_value(col0)

Aggregate
Overload link col0 Returns
#01 T T

Example

last_value example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

In other engines

Apache Hivelast_value()

SELECT LAST_VALUE(sample_col, TRUE)
In Haybarn
SELECT LAST_VALUE(sample_col IGNORE NULLS)

SQLGlot example ↗

BigQuerylast_value()

SELECT purchases, LAST_VALUE(item) OVER item_window AS most_popular FROM Produce WINDOW item_window AS (PARTITION BY purchases ORDER BY purchases ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING)
In Haybarn
SELECT purchases, LAST_VALUE(item) OVER item_window AS most_popular FROM Produce WINDOW item_window AS (PARTITION BY purchases ORDER BY purchases NULLS FIRST ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING)

SQLGlot example ↗