By default, it types the information in ascending purchase and starts assigning ranks for each row. In the above screenshot, we get ROW No 1 for marks 50. We will specify descending purchase with Get By clause, and it changes the RANK accordingly. Based on my contribution for the SQL https://eatatstreet.com