title: MYSQL 5.7 Getting the row number
body: <p>I have a database called "playerrank" that has points column. I want to show on people's profile page their rank like this:</p>
  
  <p>Rank: 3/1456</p>
  
  <p>I tried using ROW_NUMBER() but it seems like my host has low version (5.7 i believe).its giving me errors.</p>
  
  <p>Is there another way i can get the ranking of a player based on points other than ordering the db by points desc and getting the row number somehow?</p>