Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Third Highest Distinct Score

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.