query to fetch records and their rank in the DB

I have a table that holds usernames and results. When a user insert his results to the DB, I want to execute a query that will return the top X results ( with their rank in the db) and will also get that user result and his rank in the DB. the result should be like this:I have a table that holds usernames and results