Am using the sql statement below to rank student exams scores.
But the challenge i have is that when i have the same score for example 70 two times one become 2 and the other 3.
Is it possible to make both 2 and then the next number would be 4.
Thanks
SELECT Name,
Grade,
ROW_NUMBER() OVER (ORDER BY Grade DESC) AS Rank
FROM YourStudents
ORDER BY Grade DESC
Go to the complete details ...