Dense Rank

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


select Name ,Subj ,DENSE_RANK() over(partition by name order by name) as denrank from Students

Comments or Responses

Login to post response