with ranking as(select 
    *,
    rank() over(partition by department order by salary desc) as rank_number
    from employees)

select 
	department,
	employee_name,
	salary
from 
	ranking 
where 
	rank_number<=2