Why did I get runtime error? worked in MS SQL


  • 0
    W

    select Score, DENSE_RANK() OVER (ORDER BY Score DESC) as Rank
    from Scores


  • 0
    L

    Forget MS SQL. Unfortunately, MySQL does not support such DENSE_RANK() function, you might need to implement by your own, probably by using user defined variables.


Log in to reply
 

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