Why my code using dense rank doesn't work


  • 0
    S

    I was wondering why my code below using dense rank function keeps getting syntax error.

    SELECT
    Score, DENSE_RANK() OVER (ORDER BY Score) As Rank
    FROM Scores
    ORDER BY Score;


  • 0

    MySQL does not support dense_rank() analytic function.


Log in to reply
 

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