lag()

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

lag(col, offset, default)

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

Engine example with sample data · Run to view results.

More examples

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

Guide example · Run to view results.

In other engines

ClickHouselag()

SELECT lag(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees
In DuckDB
SELECT LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees

SQLGlot example ↗

Snowflakelag()

Same function