How to get the position of a record in a table relative to MySQL sort?

Question

MySQL

There is a table with data: NAME, RATING.
I need to get the position of this NAME, relative to sorting, who has a higher rating.
I would be grateful for help!

Answer 1

SELECT COUNT(*) + 1 AS `position`
  FROM `table` 
  WHERE `RATING` > (
    SELECT `RATING`
      FROM `table`
      WHERE `NAME` = :name
      LIMIT 1
  )