mysql & clinkhouse之查询 行拼接

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效果图