sql循环查询树形结构

pid：父类别id

select t.* from OA_DEPT_DOC_TYPE t start with id='704' connect by prior pid = id --查询父祖类别
union
select t.* from OA_DEPT_DOC_TYPE t start with id='704' connect by prior id = pid;--查询子孙类别

这样查询出选中id 的类别的所有父类别和所有子孙类别的数据。

转载于:https://www.cnblogs.com/clovem/p/6862417.html