DENSE_RANK

How can we rank employees contiguously without skipping numbers after ties?

Advanced⏱ 3 Minutes⭐ 1570 XP

🤔 THE QUESTION

How can we rank employees contiguously without skipping numbers after ties?

💡 WHAT IS IT?

DENSE_RANK() assigns identical ranks to ties and continues sequentially without gaps (e.g. 1, 2, 2, 3).

🎯 WHAT IS IT USED FOR?

Salary grade bands, top 3 unique compensation levels, leaderboard tiers.

💻 EXAMPLE

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

Practice typing production-grade SQL code for DENSE_RANK.