Assigns the same rank to equal values, without gaps in ranking.
Syntax
DENSE_RANK() OVER (w)Example
Enter values below to update the example in real time.
student_id→score→exam_results→-- 성적 순위 (동점 시 순위 건너뛰지 않음)
SELECT student_id, score,
DENSE_RANK() OVER (ORDER BY score DESC) AS rank
FROM exam_results;