mysql根据某个字段切割并分组,在统计

最新推荐文章于 2024-09-09 17:02:14 发布

FLYINGONE2

最新推荐文章于 2024-09-09 17:02:14 发布

阅读量1.6k

点赞数

本文链接：https://blog.csdn.net/qq_39994174/article/details/118297310

版权

参考博主网址mysql根据某个字段切割并分组,再统计

数据库表字段结构类似如下所示：

在这里插入图片描述

注：此sql不和上面的表结构相对应
select pcu.user_name userName, IFNULL(sum(investment_rmb_fee), 0)  investmentRmbFee  from  (SELECT o.investment_rmb_fee, SUBSTRING_INDEX( SUBSTRING_INDEX( pcp.principal_by, ',', b.help_topic_id + 1 ), ',',- 1 ) AS id 
FROM `a` AS pcp JOIN help_topic AS b ON b.help_topic_id < ( length( pcp.principal_by ) - length( REPLACE ( pcp.principal_by, ',', '' ) ) + 1 ) left join a_other o on o.project_id = pcp.project_id  where pcp.principal_by is not null and  pcp.principal_by != "" )  splitPcp   left join u pcu on pcu.company_user_id = splitPcp.id where pcu.user_name is not null
group by id,pcu.user_name ORDER BY investmentRmbFee desc