1965. Employees With Missing Information LeetCode Solution
In this guide, you will get 1965. Employees With Missing Information LeetCode Solution with the best time and space complexity. The solution to Employees With Missing Information problem is provided in various programming languages like C++, Java, and Python. This will be helpful for you if you are preparing for placements, hackathons, interviews, or practice purposes. The solutions provided here are very easy to follow and include detailed explanations.
Problem Statement of Employees With Missing Information
Table: Employees
+————-+———+
| Column Name | Type |
+————-+———+
| employee_id | int |
| name | varchar |
+————-+———+
employee_id is the column with unique values for this table.
Each row of this table indicates the name of the employee whose ID is employee_id.
Table: Salaries
+————-+———+
| Column Name | Type |
+————-+———+
| employee_id | int |
| salary | int |
+————-+———+
employee_id is the column with unique values for this table.
Each row of this table indicates the salary of the employee whose ID is employee_id.
Write a solution to report the IDs of all the employees with missing information. The information of an employee is missing if:
The employee’s name is missing, or
The employee’s salary is missing.
Return the result table ordered by employee_id in ascending order.
The result format is in the following example.
Example not found
Constraints not found
Complexity Analysis
Time Complexity: Google AdSense
Space Complexity: Google Analytics
1965. Employees With Missing Information LeetCode Solution in C++
SELECT Employees.employee_id
FROM Employees
LEFT JOIN Salaries
USING (employee_id)
WHERE Salaries.salary IS NULL
UNION ALL
SELECT Salaries.employee_id
FROM Salaries
LEFT JOIN Employees
USING (employee_id)
WHERE Employees.name IS NULL
ORDER BY 1; /* code provided by PROGIEZ */
1965. Employees With Missing Information LeetCode Solution in Java
N/A // code provided by PROGIEZ
1965. Employees With Missing Information LeetCode Solution in Python
