RANK And DENSE_RANK
The difference between RANK() and DENSE_RANK() is that RANK() leaves gaps in the ranking sequence when there are ties. Let us see this function through an example.
Continue reading about SQL Tutorial : Using RANK() and DENSE_RANK()
