Difference between Rank and Dense Rank #Sql #sqlserver #backenddeveloper #dataanalytics #interview

#sql #sqlserver #techinterviews #interviewquestions

Difference between Rank and Dense_Rank in SQL Server:

Both RANK() and DENSE_RANK() are window functions used to assign a rank to each row within a result set, but there is a difference in how they handle ties:

RANK() assigns the same rank to the rows that have the same values and leaves gaps between the ranks of tied rows. For example, if two rows have the same value and rank 1, the next rank will be 3.

DENSE_RANK() assigns the same rank to the rows that have the same values, but does not leave gaps between the ranks of tied rows. For example, if two rows have the same value and rank 1, the next rank will be 2.