Percentile Rank of Students
Medium
Ranking & Top-N
Return each student's name, score and relative percent rank (0 for the lowest score, 1 for the highest) rounded to two decimals. Order by score.
Table schema
Scores(name VARCHAR(50), score INT)Sample data
name | score
Amy | 50
Ben | 60
Cara | 70
Dev | 80
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.