Aggregates Aggregate

lead()

Arguments & returns

Aggregate

Overload link	`col0`	`col1`	`col2`	Returns
#01	`T`	`BIGINT`	`T`	`T`

SELECT quantity, lead(quantity) OVER (ORDER BY day) AS next
FROM (VALUES (1, 12), (2, 8), (3, 15)) AS data(day, quantity);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT lead(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees

In DuckDB

SELECT LEAD(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees