Rank with Ties — Solution & ExplanationProblems / Rank with Ties / EditorialApproachThis problem highlights the difference between RANK() and DENSE_RANK():

RANK(): If two rows tie at position 1, the next row gets position 3 (gap).

DENSE_RANK(): If two rows tie at position 1, the next row gets position 2 (no gap).

Both use the same window: PARTITION BY subject ORDER BY score DESC. The data intentionally contains ties so the output clearly shows the difference.Hints

RANK() leaves gaps after ties (1, 1, 3), while DENSE_RANK() does not (1, 1, 2).

Both functions use the same PARTITION BY and ORDER BY clauses.

In PySpark, use F.rank() and F.dense_rank() with the same Window spec.

Solve Rank with Ties yourself →