Dense Rank Salaries

Write a SQL query to assign dense ranks to unique salaries company-wide.

Expected Columns

• name
• salary
• salary_rank

Example Output

| name | salary | salary_rank | |------|--------|-------------| | Karthik Sundaram | 95000 | 1 | | Ananya Singh | 90000 | 2 | | Aarav Sharma | 85000 | 3 | | Aditya Verma | 85000 | 3 | | ... | ... | ... |