lead()

The value of expr n rows after the current row, or the default. Can IGNORE or RESPECT NULLS.

Reference: DuckDB 2.0.0

Arguments & returns

lead(col, offset, default)

window
Overload link coloffsetdefault Returns
#01 TBIGINTANY T
lead example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example with sample data · Run to view results.

More examples

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

Guide example · Run to view results.

In other engines

ClickHouselead()

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

SQLGlot example ↗

Snowflakelead()

Same function