mysql & clinkhouse之查询 行拼接

1.mysql行拼接

SELECT   GROUP_CONCAT(area_name SEPARATOR ',') from area

1.1效果图

2.clinkhouse行拼接

select groupArray(t3.enterprise_name) AS kpi_ascfrom area t1inner join bike_quotainfo t2 on t1.area_id = t2.area_idleft join permission_userprofile t3 on t3.enterprise_id = t2.enterprise_idleft join enterprise_enterpriseinfo t4 on t2.enterprise_id = t4.enterprise_idwhere t2.approve_status = 1

2.1效果图