ROW_NUMBER()

Assigns a unique row number within a result set.

Source data — Pattern 10: Window Functions

All queries run against the shared employees table (see schema.sql). This pattern introduces a sales table to demonstrate window functions including ranking, navigation, running totals, moving averages and window aggregates.

ROW_NUMBER() — source table 1

ROW_NUMBER() — source table 2

What it does

Assigns a unique row number within a result set.

Problem

Assign row numbers to sales.

SELECT *,
ROW_NUMBER() OVER(ORDER BY sales_amount DESC) AS result
FROM sales;

Result

ROW_NUMBER() — result 3

SQL · Pattern 10 — Window Functions

ROW_NUMBER()

Assigns a unique row number within a result set.

Source data — Pattern 10: Window Functions

All queries run against the shared employees table (see schema.sql). This pattern introduces a sales table to demonstrate window functions including ranking, navigation, running totals, moving averages and window aggregates.

ROW_NUMBER() — source table 1

ROW_NUMBER() — source table 2

What it does

Assigns a unique row number within a result set.

Problem

Assign row numbers to sales.

SELECT *,
ROW_NUMBER() OVER(ORDER BY sales_amount DESC) AS result
FROM sales;

Result

ROW_NUMBER() — result 3