SQL

employee.sql

select e.*
from (
    select department, max(salary) as max_salary
    from employee
    group by department
) d
join employee e
on e.salary = d.max_salary;