The very first row receives rank 1, and the subsequent rows get larger rankings. If any rows have the similar worth in the column employed for ordering, They are really ranked precisely the same. The RANK() function leaves gaps in this kind of conditions. But, be cautious when using this https://rsac.org