Use SQL query with window functions to find top 2 salaries for each department.

• Use PARTITION BY clause to partition the data by department.

• Use ORDER BY clause to order the salaries in descending order...read more

with temp as (Select department, salary, row_number() over(partition by department order by salary desc) top_sal

from emp)

select department, salary

from temp

where top_sal <= 2