Which SQL query gets the required output?

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?

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:
http://ivrainbow65.blogspot.com/

Show Hint

← Previous question

Next question →