The exact same rank is assigned to the rows that have a similar values. The ranks may not be consecutive from the RANK() operate as it adds the number of recurring rows into the recurring rank to determine the rank of another row. This promptly is sensible as you see https://www.whereisyourtoothbrush.com