What's wrong with this case?


  • 0
    L

    select Score, (select count(distinct s.Score) from Scores s where s.Score >= Score) Rank from Scores order by Score desc;

    this is my query statement, just a small difference(exchange Scores and Scores s) from the second answer of the most viewed topic. But result wrong answer;


Log in to reply
 

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