The 1st row will get rank 1, and the next rows get larger rankings. If any rows contain the very same worth in the column used for ordering, They can be ranked the exact same. The RANK() perform leaves gaps in this sort of instances. com on The subject of https://rsac.org