Mybatis中递归查询

 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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值