Calculate what place the player takes in the leaderboard?

Question

SQL

To display in the player's profile, you need to display his position, conditional 4000th place, or 1st, etc.
If I understand correctly orderBy -> score and add count to the number of users whose score is higher than the current user.
The question is how to generate a request and count the players who have more points?

Answer 1

SELECT COUNT(*) + 1 FROM <tablename> WHERE `score` > ?