SQL 문제 14 - Employees With Missing Information LeetCode 1965 Employees With Missing Information 풀이 -- ORACLE SELECT NVL(E.EMPLOYEE_ID, S.EMPLOYEE_ID) AS EMPLOYEE_ID FROM EMPLOYEES E FULL OUTER JOIN SALARIES S ON E.EMPLOYEE_ID = S.EMPLOYEE_ID WHERE SALARY IS NULL OR NAME IS NULL ORDER BY EMPLOYEE_ID; -- MYSQL SELECT EMPLOYEE_ID FROM( SELECT EMPLOYEE_ID FROM EMPLOYEES WHERE EMPLOYEE_ID NOT IN (SELECT EMPLOYEE_ID FROM SALARIES) UNION SELECT EMPLOYEE_ID FROM SALARIES WHERE EMPLOYEE_ID NOT IN (SELECT...
#EmployeesWithMissingInformation_LeetCode1965
#SQL
#SQL_EmployeesWithMissingInformation
#SQL_EmployeesWithMissingInformation_LeetCode1965
#SQL_LeetCode1965
원문링크 : SQL 문제 14 - Employees With Missing Information LeetCode 1965