Can anyone give clarification about RANK and DENSE_RANK, when they will be used in real time projects?
While using RANK function if you have say 3 records having same rank of 1, then the 4th record will have rank of 4.
Whereas if you use dense_rank you’ll get the rank in consecutive numbers.
Hope that helps!
I know how they work. But I want to know what is the real time use case of those two.