ROW_NUMBER

How can we assign sequential ranks to sorted employees without collapsing rows?

Advanced⏱ 3 Minutes⭐ 1540 XP

🤔 THE QUESTION

How can we assign sequential ranks to sorted employees without collapsing rows?

💡 WHAT IS IT?

ROW_NUMBER() OVER (ORDER BY ...) assigns a unique incrementing integer to each row in the window.

🎯 WHAT IS IT USED FOR?

Pagination, top-N leaderboards, assigning deterministic row indices.

💻 EXAMPLE

SELECT
name,
salary,
ROW_NUMBER() OVER (ORDER BY salary DESC) AS salary_rank
FROM employees;

Practice typing production-grade SQL code for ROW_NUMBER.