Return first_name, salary and rn — a row number from 1 in order of salary highest first (ties broken by emp_id).
20 rows with columns first_name, salary, rn — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Anita | 250000 | 1 |
| 2 | Rahul | 180000 | 2 |
| 3 | Vikram | 160000 | 3 |
Run your code to see the output here.