Mybatis中递归查询

最新推荐文章于 2023-09-22 20:28:52 发布

YerikStone

最新推荐文章于 2023-09-22 20:28:52 发布

阅读量273

点赞数 1

CC 4.0 BY-SA版权

分类专栏： sql数据库

本文链接：https://blog.youkuaiyun.com/YerikStone/article/details/115913488

sql数据库专栏收录该内容

4 篇文章

订阅专栏

 SELECT u2.abi_one_id,u2.real_name,apt.type_name, right(type_name, 1) as type_code,
            u2.manager_emp_no,u2.employee_no, manager_name
        FROM(
                SELECT
                    @ids AS p_ids,
                    (SELECT @ids := GROUP_CONCAT(employee_no) FROM abi_user WHERE FIND_IN_SET(manager_emp_no, @ids)) AS c_ids,
            @l := @l+1 AS LEVEL
        FROM abi_user, (SELECT @ids := #{managerEmpNo}, @l := 0 ) b
        WHERE @ids IS NOT NULL and abi_user.deleted = 0
            ) u1
            JOIN abi_user u2
        ON FIND_IN_SET(u2.employee_no, u1.p_ids)
            LEFT JOIN abi_position_type apt ON u2.position_type_id = apt.id
        where u2.deleted = 0 and apt.type_name is not null and  employee_no != #{managerEmpNo}

参考：https://blog.youkuaiyun.com/weixin_43703769/article/details/109254934