关于start -whit-prior 的使用
语法
SELECT … FROM + 表名 WHERE + 条件3 START WITH + 条件1 CONNECT BY PRIOR + 条件2 示例 Select * From DEMO Start With ID = ‘00001’ Connect By Prior ID = PID
查询区别
select * from sys_dept a start whit a.dept_id = ‘4’ connect by prior a.parent_dept_id = a.dept_id; //从子到父
select * from sys_dept a start whit a.dept_id = ‘1’ connect by prior a.parent_dept_id = a.dept_id; //从父到子
