SELECT dept_Id, parent_Id FROM DEPT START WITH dept_Id= '1' Connect BY Prior dept_Id = parent_Id
字段名-子ID:dept_Id
字段名-父ID:parent_Id
START WITH:从哪一代开始查找,它的ID是什么?将参数写入条件
CONNECT BY PRIOR:关联的2个字段名
原文链接:https://blog.csdn.net/qq_21440541/article/details/107126317