View the Exhibit and examine the details of the EMPLOYEES table. You want to generate a hierarchical report for all the employees who report to the employee whose EMPLOYEE_ID is 100. Which SQL clauses would you require to accomplish the task? (Choose all that apply.)

Question

Accepted Answer

A. WHERE D. START WITH E. CONNECT BY

Answer

B. HAVING

Answer

C. GROUP BY

View the Exhibit and examine the details of the EMPLOYEES table. You want to generate a hierarchical report for all the employees who report to the employee whose EMPLOYEE_ID is 100. Which SQL…

Question

Options

How the community answered

Community Discussion