Select the suitable option for retrieving all the employees who have a manager?
Answer options
A
SELECT empname, manager_id FROM employee WHERE manager_id IS NOT NULL;
B
SELECT * FROM employee WHERE manager_id = NULL;
C
SELECT * FROM employee WHERE manager_id != 0;
D
SELECT * FROM employee;
Correct answer: SELECT empname, manager_id FROM employee WHERE manager_id IS NOT NULL;
Explanation
Quick AnswerThe correct answer is SELECT empname, manager_id FROM employee WHERE manager_id IS NOT NULL; because it directly addresses the core logic of Database Management.
Use IS NOT NULL to filter rows where manager_id has a value.