select * from deptment d start with d.dep_parent_id in (select t.dep_id from test_depview t) connect by prior d.dep_id = d.dep_parent_id;
start with ....... connect by prior 递归查询 , 如果不加prior 则不进行深入递归查查询
2021-09-07 09:27:02
select * from deptment d start with d.dep_parent_id in (select t.dep_id from test_depview t) connect by prior d.dep_id = d.dep_parent_id;
start with ....... connect by prior 递归查询 , 如果不加prior 则不进行深入递归查查询
下一篇:mysql共享锁与排他锁