Return dept_id, first_name and salary for the top 2 distinct salaries in each department (people tied on a salary are all included).
11 rows with columns dept_id, first_name, salary — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 3 | Aditya | 120000 |
| 2 | 3 | Karan | 55000 |
| 3 | 4 | Neha | 110000 |
Run your code to see the output here.