last_value
Repeat the last value in a window frame.
Try an expression
In Formula, enter the expression and set Output type to INTEGER.
Example input
- Row 1
id = 1, amount = 10 - Row 2
id = 2, amount = NULL - Row 3
id = 3, amount = 30 - Row 4
id = 4, amount = 30
Expression
last_value(amount) OVER (ORDER BY id ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)Result
Row 1: 30
Row 2: 30
Row 3: 30
Row 4: 30NULL means the value is missing.
Arguments and types
last_value(expr[ ORDER BY ordering][ IGNORE NULLS])The result type can depend on the input types. See DuckDB for the full argument rules.
Things to know
ORDER BY defines the order used by the calculation; it doesn't sort the output table. Include a unique tie-breaker when row position matters. Window expressions belong in Formula and can't be entered directly in Filter.
This example explicitly includes the whole partition in its frame. Without that frame, the last value can be the current row instead.
Function metadata from DuckDB, used under the MIT license.