SQL · Window functions

lead() with offset

Looks ahead by n rows.

sqlRunnable example sql course

Syntax

lead(column, n) over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20), (30))
SELECT minutes, lead(minutes, 2) OVER (ORDER BY minutes) AS in_two FROM lessons;

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