2127. Employees Whose Manager Left the Company
My accepted SQL solution to LeetCode problem 2127, Employees Whose Manager Left the Company, running in 278ms.
- Difficulty: Easy
- SQL
- Runtime 278ms
- 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 278ms, memory 0.0B, accepted 2025-12-31.
SELECT employee_id
FROM Employees
WHERE salary < 30000
AND manager_id IS NOT NULL
AND manager_id NOT IN (SELECT employee_id FROM Employees)
ORDER BY employee_id