List dept_id, first_name and salary of employees who have a department, sorted by dept_id ascending and, within each department, by salary highest first.
19 rows with columns dept_id, first_name, salary — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 1 | Anita | 250000 |
| 2 | 1 | Rahul | 180000 |
| 3 | 1 | Priya | 140000 |
Run your code to see the output here.