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博客 ” ，链接：https://blog.itpub.net/88933/viewspace-675664/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
047试题请教
请登录后发表评论
登录
全部评论
