The behavioral difference between RANK and RANK_DENSE when there are tied values — shared ranks vs. consecutive ranks with no gaps.