[SQL문제풀기] Finding Updated Records

문제

StrataScratch - Finding Updated Records

StrataScratch

https://platform.stratascratch.com/coding/10299-finding-updated-records?code_type=7

MySQL

내가 작성한 오답

select id, first_name, last_name, department_id, max(salary) current_salary
from ms_employee_salary
group by id, first_name, last_name, department_id
order by 1;

내가 작성한 정답

select a.id, a.first_name, a.last_name, b.department_id, a.current_salary
from (select id, first_name, last_name, max(salary) current_salary
        from ms_employee_salary
        group by id, first_name, last_name) a
join ms_employee_salary b
on (a.id,a.current_salary) = (b.id,b.salary)
order by 1;

ORACLE

내가 작성한 정답

select a.id, a.first_name, a.last_name, b.department_id, a.current_salary
from (select id, first_name, last_name, max(salary) current_salary
        from ms_employee_salary
        group by id, first_name, last_name) a
join ms_employee_salary b
on a.id= b.id and a.current_salary=b.salary
order by 1;