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 3

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


laura

laura

why where is required?

Alli Pierre

Alli Pierre

Where can to be use in a hierarchical report

laura

laura

I know, but why it is required in this example? you can specify the employee_id in start with cluase. right?