View the Exhibit and examine the structure of the EMPLOYEES table.You want to retrieve hierarchical data of the employee
Posted: Wed Jun 07, 2023 6:11 am
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. WHERE
B. HAVING
C. GROUP BY
D. START WITH E. CONNECT BY PRIOR
A. WHERE
B. HAVING
C. GROUP BY
D. START WITH E. CONNECT BY PRIOR