What is r for the score 80?
-- scores: 90, 90, 80 SELECT score, RANK() OVER (ORDER BY score DESC) AS r FROM t;
- 1
- 4
- 3
- 2
RANK leaves gaps after ties: both 90s are rank 1, so 80 is rank 3 (DENSE_RANK would give 2).r for the score 80?-- scores: 90, 90, 80 SELECT score, RANK() OVER (ORDER BY score DESC) AS r FROM t;
RANK leaves gaps after ties: both 90s are rank 1, so 80 is rank 3 (DENSE_RANK would give 2).