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, 'NoManager1 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
Examine the structure of the employees table:There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.You
-
- Site Admin
- Posts: 899566
- Joined: Mon Aug 02, 2021 8:13 am