您的位置: 首页 > IT文章 > 查询父级机构sql 查询父级机构sql 分类: IT文章 • 2023-12-04 22:16:13 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;