what is the main difference between rank and dense_rank functions in oracle?
RANK: This gives you the ranking within your ordered partition. Ties are assigned the same rank, with the next ranking(s) skipped. Therefore, if you have 3 items at rank 2, the next rank listed will be ranked 5. DENSE_RANK: This gives you the ranking within your ordered partition, but the ranks are consecutive in it.