코딩테스트/리트코드(LeetCode) - SQL Study Plan

리트코드(LeetCode) SQL 문제풀이 - 1965. Employees With Missing Information

진한색 2023. 1. 22. 16:39

 

select employee_id from Salaries
    where employee_id not in (select employee_id from Employees)
union
select employee_id from Employees
    where employee_id not in (select employee_id from Salaries)
order by employee_id
728x90