How to find out the serial number of a row when sorting?

Question

MySQL

There are posts, each post has a rating. Is it possible to find out the position of a post in the top, knowing only its rating? Something like, sort by rating and pull out a position in this sort by post id.

Answer 1

Count the number of rows whose rating is greater than the given one (if the record with the highest rating is in the top).

SELECT COUNT(*) 
FROM `posts` 
WHERE `rating` > (
    SELECT `rating` 
    FROM `posts` 
    WHERE `id` = 42
)

Answer 2

SET @Couner = 0;
SELECT @Counter := @Counter + 1, * FROM table;
And then from the resulting table we select a position by rating.

Answer 3

Find out the position of a post with a rating of 100:
Pull out a post by id:
There may be a problem if there are several posts with a rating of 100...