SQL · Window functions

lag() with default

Uses a default when the previous row does not exist.

sqlRunnable example sql course

Syntax

lag(column, 1, 0) over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20))
SELECT minutes, lag(minutes, 1, 0) OVER (ORDER BY minutes) AS previous FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.