[SQL문제풀기] Highest Salary In Department

silver

Feb 02, 2026

Contents

문제 내가 작성한 정답

문제

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);