Prev Question
Next Question

View the Exhibit and examine the details of the EMPLOYEES table.

5a104979eb3c0 - Which SQL clauses would you require to accomplish the task?

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.)

A.
WHERE

B.
HAVING

C.
GROUP BY

D.
START WITH

E.
CONNECT BY

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *