Return dept_id, first_name, salary and dept_rank — RANK by salary within each department (highest = 1). Skip employees with no department.
19 rows with columns dept_id, first_name, salary, dept_rank — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 3 | Aditya | 120000 | 1 |
| 2 | 3 | Karan | 55000 | 2 |
| 3 | 3 | Pooja | 50000 | 3 |
Run your code to see the output here.