Examine the structure of the employees table:
There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the name, joining date, and manager for all the employees. Newly hired employees are yet
to be assigned a department or a manager. For them, ‘No Manager1 should be displayed in the manager
column.
Which SQL query gets the required output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
We should use LEFT OUTER JOIN as we want to display employees which have no (have NULL values for)
managers.