Which SQL clause would let you choose the direction to walk through the hierarchy tree?

View the Exhibit and examine the structure of the EMPLOYEES table. You want to retrieve
hierarchical data of the employees using the top-down hierarchy. Which SQL clause would
let you choose the direction to walk through the hierarchy tree?

View the Exhibit and examine the structure of the EMPLOYEES table. You want to retrieve
hierarchical data of the employees using the top-down hierarchy. Which SQL clause would
let you choose the direction to walk through the hierarchy tree?

A.
CONNECT BY PRIOR

B.
START WITH

C.
WHERE

D.
GROUP BY

E.
HAVING



Leave a Reply 0

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