How to get the row number in the selection and the slice of the selection around this row?

Question

MySQL

There is a users table with id and points fields, points is of double type.
How, knowing the user id, to get the line number with this user in the selection sorted by points?
That is, it will be the user's place in the ranking.
And how to get 5 users before and 5 users after this user in the rating?

Answer 1

select * from tbl order by user.rating - :target
union
select * from tbl order by :target - user.rating

Set your own limit.

Answer 2

https://dev.mysql.com/doc/refman/8.0/en/window-fun...