How to combine 2 sql queries?

Question

PHP

Have a request

SET @n = 0;
SELECT (@n := @n + 1) AS rank, id, votes, game
FROM servers ORDER BY votes DESC;

I need to put forward a request to this after this request to display a specific line by id

Answer 1

wrap in another select

SELECT *
FROM (<ваш селект>) AS a
WHERE a.rank = 1

but if you need the third place, for example, in the votes field, then it's easier to do this

SELECT id, votes, game
FROM servers 
ORDER BY votes DESC
LIMIT 2,1