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

Explanation:



Leave a Reply 0

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