Database & utility
window
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 |
Example
1 more ↓Haybarn WASM 2.0.0-rc12 · In your browser
Engine example with sample data · Run to view results.
More examples
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)
SELECT LAST_VALUE(sample_col IGNORE NULLS)
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)
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)