Assign row numbers within each user

sql

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

Explanation

Helpful for picking latest rows per entity.

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 functions

Compute cumulative revenue by day.

Open In sheetsqlsame section

Calculate day-over-day change.

Open In sheetsqlsame section

Rank categories by revenue without gaps.

Open In sheetsqlsame section

Return the total number of rows in a table.

Count orders by status.

Calculate totals and averages.