[LeetCode] 1789. Primary Department for Each Employee

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT employee_id
     , department_id
FROM Employee
WHERE primary_flag = 'Y'

UNION

SELECT employee_id
     , department_id
FROM Employee
WHERE employee_id NOT IN (SELECT employee_id
                            FROM Employee
                            WHERE primary_flag = 'Y')