-
1965. Employees With Missing Information mysqlLeetCode_Study_Plan/SQL 2022. 9. 29. 14:47
https://leetcode.com/problems/employees-with-missing-information/?envType=study-plan&id=sql-i
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 employee_id FROM Employees) ORDER BY employee_id;
'LeetCode_Study_Plan > SQL' 카테고리의 다른 글
175. Combine Two Tables mysql (0) 2022.09.30 1795. Rearrange Products Table mysql (0) 2022.09.29 1527. Patients With a Condition mysql (0) 2022.09.27 1484. Group Sold Products By The Date mysql (0) 2022.09.27 1667. Fix Names in a Table oracle (0) 2022.09.27