SQL · Functions and expressions

row_number()

Assigns a sequential number to rows within a window.

sqlRunnable example sql course

Syntax

row_number() over (…)

Example

Open in the lab

WITH lessons(title, minutes) AS (VALUES ('HTML', 12), ('CSS', 18))
SELECT title, row_number() OVER (ORDER BY minutes DESC) AS position FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.