Difference between RANK() and DENSE_RANK() in sql server.

Question

Sunil Singh · Answer

RANK Function skips rankings if there is a tie where as DENSE_RANK willnot
For example
If you have 2 rows at rank 1 and you have 5 rows in total
Rank() returns-1, 1, 3, 4, 5
DENSE_RANK RETURN - 1, 1, 2, 3 ,4
lets take an example to understandUsing rank()select Name,salary,
rank() over (Order by Salary desc) as [rank] from salary
Using dense_rank()select Name,salary,
dense_rank() over (Order by Salary desc) as [rank] from salaryoutput

forum

Difference between RANK() and DENSE_RANK() in sql server.

Manish Kumar

Can you answer this question?

1 Answers

Using rank()

Using dense_rank()

output

Liked By