Return first_name, salary and salary_rank using RANK (highest salary = 1; ties share a rank and leave gaps).
20 rows with columns first_name, salary, salary_rank — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Anita | 250000 | 1 |
| 2 | Rahul | 180000 | 2 |
| 3 | Vikram | 160000 | 3 |
Run your code to see the output here.