Examine the structure of the employees table:There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.You
Posted: Sun Jun 11, 2023 3:51 pm
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 Str 1 (58.1 KiB) Viewed 295 times
- Examine The Str 2 (98.05 KiB) Viewed 295 times
B. Option B
C. Option C
D. Option D