1.mysql行拼接
SELECT GROUP_CONCAT(area_name SEPARATOR ',') from area
1.1效果图
2.clinkhouse行拼接
select groupArray(t3.enterprise_name) AS kpi_asc from area t1 inner join bike_quotainfo t2 on t1.area_id = t2.area_id left join permission_userprofile t3 on t3.enterprise_id = t2.enterprise_id left join enterprise_enterpriseinfo t4 on t2.enterprise_id = t4.enterprise_id where t2.approve_status = 1
2.1效果图
