I want to get the rank of certain SteamID, I know how to do the "top", where with just a ORDER BY I can get it. But not get the rank number of someone.
The diference is that, with just an ORDER BY I can get who are the ten players who have the highest XP, but if I want to know the rank of certain player, I cant.
Keep in mind that I think to show this in a HUD, so It shouldn't burn the CPU. I don't ask for queriyng every second, but maybe every round.