Creating a row for the rank


  • 0
    Z

    select a.Score, Rank from Scores a,
    (select Score, rownum as Rank from Scores order by Score desc) b
    where a.score = b.score
    order by score;


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.