ORACLE--Connect By、Level、Start With的使用(Hierarchical query-层次查询)
摘要：
查找员工编号为7369的领导: 1 SELECT LEVEL,E.* FROM EMP E CONNECT BY PRIOR E.MGR = E.EMPNO START WITH E.EMPNO = 78762 ORDER BY LEVEL DESC "start with" --... 阅读全文
posted @ 2013-06-22 07:48 毛小娃 阅读(380) 评论(0) 推荐(0) 编辑
