last_value()

The last value of expr in the frame. Can IGNORE or RESPECT NULLS.

Reference: DuckDB 2.0.0

Arguments & returns

last_value(expr)

window
Overload link expr Returns
#01 ANY ANY
last_value example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example with sample data · Run to view results.

More examples

last_value example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Guide example · Run to view results.

In other engines

Apache Hivelast_value()

SELECT LAST_VALUE(sample_col, TRUE)
In DuckDB
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 DuckDB
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 ↗