sql 上下级 树状查询

表里有上下级机构的，建立 parent_dept_id

 

根据传入id得到所有上级id

select id from dept start with id = ? connect by prior parent_dept_id = id

 根据上级得到所有下级id

select id from dept start with t.id = ? connect by prior t.id = t.parent_dept_id order by t.id