RANK(): Handling Ties with Gaps

Using RANK() to assign rankings that leave gaps after tied values (e.g., 1, 2, 2, 4).