Assign row numbers

sql

SELECT order_id, customer_id, created_at,
       ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY created_at DESC) AS rn
FROM orders;

Explanation

ROW_NUMBER is useful for deduping and top-N-per-group queries.

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 Window Function Basics

Assign ordered rankings with or without gaps.

Open In sheetsqlsame section

Accumulate values across an ordered window.

Open In sheetsqlsame section

Compute metrics per partition while keeping each row.

Open In sheetsqlsame section

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

Open In sheetsql1 tag match

Divide ordered rows into a fixed number of groups.

Open In sheetsql1 tag match

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

Open In sheetsql1 tag match