Dense Rank : Returns the rank of rows within the partition of a result set, without any gaps in the ranking. The rank of a row is one plus the number of distinct ranks that come before the row in question.
Example: select Name ,Subj ,DENSE_RANK() over(partition by name order by name) as denrank from Students