Which SQL clauses would you require to accomplish the task?

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

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

A.
WHERE

B.
HAVING

C.
GROUP BY

D.
START WITH

E.
CONNECT BY



Leave a Reply 0

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