Third Highest Distinct Score
Medium
Ranking Edge Cases
Return the students holding the third highest distinct score (use dense ranking). Return name and score.
Table schema
Scores(name VARCHAR(10), score INT)Sample data
name | score
Ann | 90
Bob | 90
Cy | 80
Dee | 70
Eli | 70
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.