How to determine where in the ranking a user is?

Question

PHP

There is a list of users, each has a percentage of progress.
I need the user to see where he is among all the students.
I've been trying to find similar information for a long time but I can't.

Answer 1

window function. ROW_NUMBER . Or RANK . The implementation is determined by the specific DBMS.

Answer 2

What DB? Mysql has variables and you can do something like this:

SELECT    name,
          percent,
          @curRank := @curRank + 1 AS rank
FROM      students s, (SELECT @curRank := 0) r
ORDER BY  percent desc;

(I can't vouch for the syntax)
The normal way to do this, and now more or less portable, is via window functions:

SELECT name,
       percent,
       dense_rank() over (order by percent desc) rating
  FROM students
 ORDER BY 1;

Answer 3

Lord, people have forgotten how to write SQL
just a little - variables, window functions. write the procedure

SELECT count(*)+1 FROM players WHERE score > (SELECT score FROM players WHERE id = ?)