PHP Code:
SELECT name, kills FROM tablename_here ORDER BY kills DESC LIMIT 10 
I'm pretty sure this is NOT exactly what you want, but this follows your request. So please clarify your request.