2110. Employees With Missing Information
My accepted SQL solution to LeetCode problem 2110, Employees With Missing Information, running in 506ms.
- Difficulty: Easy
- SQL
- Runtime 506ms
- Memory 0.0B
- Updated
Read the problem on LeetCode View on GitHub
The problem statement is LeetCode’s and stays on their site. What follows is my accepted solution.
SQL
Accepted on LeetCode — runtime 506ms, memory 0.0B, accepted 2025-12-31.
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