Compare ROW_NUMBER, RANK, and DENSE_RANK on the same dataset.

Answer preview

Run all three ranking functions over the same ORDER BY salary DESC window so the tied 180000 salaries show exactly how they diverge.…