--数形查询出所有的相关数据
select a.empno,a.ename,a.mgr,b.lv
from emp a
left join emp_level b on(b.empno=a.empno)
start with a.empno=7876
connect by ((prior a.mgr)=a.empno
and (prior b.lv)>2);
也是看书的 prior b.lv >2 请大神求教?
--数形查询出所有的相关数据
select a.empno,a.ename,a.mgr,b.lv
from emp a
left join emp_level b on(b.empno=a.empno)
start with a.empno=7876
connect by ((prior a.mgr)=a.empno
and (prior b.lv)>2);
也是看书的 prior b.lv >2 请大神求教?
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
