Rank vs Dense Rank vs Row Number
Medium
Window Functions
For each student return name, score, RANK, DENSE_RANK and ROW_NUMBER ordered by score descending (break row-number ties by name).
Table schema
Scores(name VARCHAR(50), score INT)Sample data
name | score
Amy | 90
Ben | 90
Cara | 80
Dev | 70
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.