SELECT code , name , creationtime , ts , pk_dept , pk_fatherorg FROM org_dept where name = ‘人力资源部’
and pk_org = ‘0001A6100000000003DQ’ and pk_dept not in( SELECT pk_fatherorg from org_dept where name = ‘人力资源部’
and pk_org = ‘0001A6100000000003DQ’)
查询父子部门中相同名字的最末级部门
于 2022-10-21 01:24:09 首次发布