Friday, January 17, 2014

RANK() VS DENSE_RANK()

 The RANK () function in SQL Server returns the position of a value within the partition of a result set, with gaps in the ranking where there are ties.

The DENSE_RANK () function in SQL Server returns the position of a value within the partition of a result set, leaving no gaps in the ranking where there are ties.

Let us understand this difference with an example and then observe the results while using these two functions:



Example for RANK

Rank
Name
Age
1
Ram
20
2
Shayam
21
2
Sohan
21
4
Rohit
23
4
Rohan
23
4
Raj
23
7
XYZ
24
8
YZ
25
 
Example of Dense Rank
Dense Rank
Name
Age
1
Ram
20
2
Shayam
21
2
Sohan
21
3
Rohit
23
3
Rohan
23
3
Raj
23
4
XYZ
24
5
YZ
25
 
Keyword: TSQL Interview Questions, SQL Server Interview Questions and Answers,Rank Vs Dense Rank.

No comments:

Post a Comment