DDSA Solutions

178. Rank Scores

UnknownView on LeetCode
Database

Problem Overview

Rank Scores is a unknown-difficulty LeetCode problem. This is a common Database pattern in coding interviews. Study the solution below and note the time and space complexity before attempting variations on your own.

A full step-by-step explanation is being added. See the study guide for pattern-based practice.

Read the solution code below and trace through it on paper before submitting. For structured interview prep, follow our 30-day study guide.

178.sql
MySQL
SELECT
  score,
  DENSE_RANK() OVER(ORDER BY score DESC) AS rank
FROM Scores
ORDER BY score desc;
Was this solution helpful?

Related Problems