Last 7 rows

sql

ROWS BETWEEN 6 PRECEDING AND CURRENT ROW

Explanation

A classic moving window for row-based smoothing.

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 Frame clause cheatsheet

Single-row frame.

Open In sheetsqlsame section

Forward-looking frame.

Open In sheetsqlsame section

Every row in the current partition.

Open In sheetsqlsame section

Return total row count on every row.

Compute a per-customer total on every row.

Number rows in order within each customer.