SQL: Score Ranking with Ties (RANK vs DENSE_RANK)

MediumDatabases

Description

> This problem is paper-only - see explanation for the canonical SQL solution. Given `Scores(id, score)`, return each score with its **DENSE_RANK** (no gaps after ties), sorted by rank ascending then id ascending. **For the auto-grader:** return `[{ id, score, rank }]`.

Example 1

Input: scores = [{id:1,score:90},{id:2,score:85},{id:3,score:90},{id:4,score:70}]

Output: [{id:1,score:90,rank:1},{id:3,score:90,rank:1},{id:2,score:85,rank:2},{id:4,score:70,rank:3}]

Explanation: Two 90s tie at rank 1. Next score 85 is rank 2 (no gap, that's DENSE_RANK).

Constraints

- 0 <= scores.length <= 10^4 - score is a non-negative integer.

Loading editor...