I have a table which stores high-scores, along with player ids. I want to be able to extract a record by a players id, and then get the rank, or position of their score in the table.
“SELECT * FROM high_scores ORDER BY game_score DESC”;
Will give me the results ordered by score, highest to lowest, but how can I then get a record from it and determine where in the table this score is placed?
