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
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Examine the structure of the employees table:There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.You
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!