The first row will get rank 1, and the following rows get increased rankings. If any rows hold the exact same value in the column employed for ordering, They're ranked a similar. The RANK() operate leaves gaps in such scenarios. No you can promise a #1 ranking on Google. Beware https://rsac.org