mysql递归查询(向上查询、向下查询)
– 递归查询部门下的所有子部门(包含当前部门)SELECT id,departmentname,subcompanyid FROM hrmdepartment WHERE id=178UNION ALL select id,departmentname,subcompanyid from ( select t1.id,t1.departmentname,t1.subcompanyid, if(find_in_set(supdepti
原创
2021-06-11 17:56:21 ·
4219 阅读 ·
0 评论