[SQL문제풀기] Highest Salary In Department

문제

StrataScratch - Highest Salary In Department

StrataScratch

https://platform.stratascratch.com/coding/9897-highest-salary-in-department?code_type=3

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select department, first_name, salary
from employee
where (department, salary) in (select department, max(salary)
                                from employee
                                group by department);