January 3, 2013

what is the use of rank and dense_rank function?

rank() assigns each row a unique number (rank) giving identical ranking for duplicate 
values,leaving a gap in the sequence to the next rank.

dense rank() similar to rank(), it leaves no gaps in the rank after identical ranking.
this link http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php

No comments:

Post a Comment