By default, it sorts the information in ascending buy and begins assigning ranks for each row. In the above screenshot, we get ROW number 1 for marks fifty. We could specify descending get with Buy By clause, and it adjustments the RANK accordingly. Dependant on my contribution for the SQL https://eatatstreet.com