查询父级机构sql

select * from sm_organ_tb start with organ_no = '111111' connect by prior parent_organ=organ_no;

 

select * from sm_organ_tb where organ_no <> '111111' start with organ_no = '111111' connect by prior parent_organ=organ_no;