SQL · Functions and expressions

rank() / dense_rank()

Ranks rows, leaving gaps after ties; dense_rank leaves no gaps.

sqlRunnable example sql course

Syntax

rank() over (…)

Example

Open in the lab

WITH scores(name, score) AS (VALUES ('Ada', 90), ('Linus', 90), ('Grace', 85))
SELECT name, rank() OVER (ORDER BY score DESC) AS place FROM scores;

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