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
why where is required?
Where can to be use in a hierarchical report
I know, but why it is required in this example? you can specify the employee_id in start with cluase. right?