Next row with LEAD

sql

SELECT day,
       revenue,
       LEAD(revenue) OVER (ORDER BY day) AS next_revenue
FROM daily_revenue;

Explanation

Use `LEAD` for forward-looking comparisons or interval construction.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing LAG and LEAD basics

Pull the previous value in order.

Open In sheetsqlsame section

Avoid NULL on the first row.

Open In sheetsqlsame section

Custom offset with LAG.

Open In sheetsqlsame section

Subtract the previous day's value.

Compute relative change versus previous row.

Measure time since the prior event.