SQL: DENSE_RANK()

In a nutshell

The DENSE_RANK() window function assigns a unique rank to each district row within a result set.

Example

Given this students table:

This query:

SELECT 
  name,
  score,
  DENSE_RANK() OVER (ORDER BY score DESC) as `rank`
FROM students;

Will produce this result:

The order of ranking is determined by the ORDER BY cause within the DENSE_RANK() function.

Other notes

• Unlike RANK(), DENSE_RANK() will give duplicate rows the same rank and not skip any rankings.