select
t.department,
t.employee_name,
t.salary
from
(select
department,
employee_name,
salary,
row_number() over(partition by department order by salary desc) as rk
from
employees) t
where
t.rk <= 2
order by
1



京公网安备 11010502036488号