Aggregates Aggregate

lag()

Arguments & returns

Aggregate

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

SELECT quantity, lag(quantity) OVER (ORDER BY day) AS previous
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 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