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

Prev Question
Next Question

View the Exhibit and examine the structure of the EMPLOYEES table.

Exam 1Z0-047 - Which SQL clause would let you choose the direction to walk through the hierarchy tree?

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

B.
HAVING

C.
GROUP BY

D.
START WITH

E.
CONNECT BY PRIOR

Prev Question
Next Question

Leave a Reply

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