Use LAG

sql

SELECT day, total_sales,
       LAG(total_sales) OVER (ORDER BY day) AS previous_day_sales
FROM daily_sales;

Explanation

LAG is great for deltas, trend analysis, and change detection.

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, Lead, and Value Navigation

Read a value from the next row in the same partition.

Open In sheetsqlsame section

Return boundary values within a window frame.

Open In sheetsqlsame section

Number rows within an ordered partition.

Open In sheetsql1 tag match

Divide ordered rows into a fixed number of groups.

Open In sheetsql1 tag match

Assign ordered rankings with or without gaps.

Open In sheetsql1 tag match

Measure relative row position inside an ordered set.

Open In sheetsql1 tag match