SQL ROW_NUMBER()

How can we assign sequential ranking integers to sorted rows without collapsing them?

Advanced⏱ 3 Minutes⭐ 440 XP

🤔 THE QUESTION

How can we assign sequential ranking integers to sorted rows without collapsing them?

💡 WHAT IS IT?

ROW_NUMBER() assigns a unique sequential number to each row within the defined window frame.

🎯 WHAT IS IT USED FOR?

Top-N filtering per group, pagination, deduplicating records by picking row number 1.

💻 EXAMPLE

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

Practice typing production-grade SQL code for SQL ROW_NUMBER().