select posts,term,user_name,GROUP_CONCAT(put_department) put_dept from hrbp_info group by posts,term,user_name having count(*)>1
多个字段条件相同进行分组并过滤拼装SQL
最新推荐文章于 2023-08-14 17:36:38 发布
select posts,term,user_name,GROUP_CONCAT(put_department) put_dept from hrbp_info group by posts,term,user_name having count(*)>1