What's wrong with this case?

  • 0

    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.