medium10 pts · first answer countssqlwindow-functions
RANK vs DENSE_RANK after a tie
Exam scores are 95, 90, 90 and 80. Ordered by score descending, what do RANK() and DENSE_RANK() give the student with 80?
Exam scores are 95, 90, 90 and 80. Ordered by score descending, what do RANK() and DENSE_RANK() give the student with 80?