Note that rank function will assign same number if there is a tie and it will skip those many numbers.

From the above example there are two employees have salary of 7500 and rank assigned in 4 and next rank is 6. So it skipped rank number 5. You can use DENSE_RANK() function for without skipping numbers.

Post navigation

4 thoughts on “Oracle RANK function”

Greetings from California! I’m bored at work so I decided to
browse your blog on my iphone during lunch break.
I enjoy the knowledge you provide here and can’t wait to take
a look when I get home. I’m amazed at how quick your blog
loaded on my cell phone .. I’m not even using WIFI, just 3G
.. Anyways, amazing blog!