Why my code using dense rank doesn't work

  • 0

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

    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.