RANK and DENSE_RANK Comparison
Medium
window-functions
Uber
Stripe
Two Sigma
Write a query to show the RANK() and DENSE_RANK() of employees by salary descending. Return name, salary, salary_rank, and salary_dense_rank, ordered by salary DESC.
Expected Output: Employees with both rank types showing gap behavior.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...