Imagine there is a table with users logins and their scores:
+----+-------+-------+
| id | login | score |
+----+-------+-------+
| 1 | log1 | 4 |
+----+-------+-------+
| 2 | log2 | 4 |
+----+-------+-------+
| 3 | log3 | 28 |
+----+-------+-------+
| 4 | log4 | 1 |
+----+-------+-------+
| 5 | log5 | 3 |
+----+-------+-------+
How to select the rank of a specific user (for example: "log2")?
The very important thing is that this selected rank shoud increase even in case of equal scores so every user will have a unique rank.
Example of how rank shoud be counted:
+----+-------+-------+------+
| id | login | score | rank |
+----+-------+-------+------+
| 1 | log1 | 4 | 2 |
+----+-------+-------+------+
| 2 | log2 | 4 | 3 |
+----+-------+-------+------+
| 3 | log3 | 28 | 1 |
+----+-------+-------+------+
| 4 | log4 | 1 | 5 |
+----+-------+-------+------+
| 5 | log5 | 3 | 4 |
+----+-------+-------+------+
Example of output:
+----+-------+-------+------+
| id | login | score | rank |
+----+-------+-------+------+
| 2 | log2 | 4 | 3 |
+----+-------+-------+------+