What are the differences between SQL RANK and DENSE_RANK functions?

Question

Accepted Answer

Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.

Rank assigns consecutive integers to each distinct value based on their order.
Dense rank also assigns consecutive integers, but does not leave gaps between ranks.
For example, if we have values 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3.

Accepted Answer

I think it is ROW_NUMBER() definition not RANK() in the answer.

Accepted Answer

RANK can result in gaps in the ranking sequence, while DENSE_RANK will always produce consecutive rankings without gaps.

Accepted Answer

RANK can result in gaps in the ranking sequence, while DENSE_RANK will always produce consecutive rankings without gaps.

Interview Questions from Popular Companies