lead
Compare each row with a value from a later row.
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
lead(amount) OVER (ORDER BY id)Result
Row 1: NULL
Row 2: 30
Row 3: 30
Row 4: NULLNULL means the value is missing.
Arguments and types
lead(expr[, offset[, default]][ 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.
Missing values occupy positions by default. The last row has no following value, so this example returns NULL there.
Function metadata from DuckDB, used under the MIT license.