Dense Rank

Arul44ece
Posted by Arul44ece under Sql Server category on | Points: 40 | Views : 1544
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

Comments or Responses

Login to post response