Rank Sql Sequence

src/data/question-groups/data-science/content/rank-sql-sequence.md

4.0166 B

Given values: 100, 90, 90, 80
RANK(): Skips ranks after ties
→ 1, 2, 2, 4
DENSE_RANK(): No skipping
→ 1, 2, 2, 3
ROW_NUMBER(): Ignores ties
→ 1, 2, 3, 4