144. 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
Answer: ADE
这个题目为什么需要使用where语句？
select * from employee start with manager_id = 101 connect by prior employee_id = manager_id
这样不满足题目要求吗？
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
Answer: ADE
这个题目为什么需要使用where语句？
select * from employee start with manager_id = 101 connect by prior employee_id = manager_id
这样不满足题目要求吗？
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/88933/viewspace-675664/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/88933/viewspace-675664/
1578
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
