mysql 的 GROUP_CONCAT

GROUP_CONCAT 通常跟 group by 一起用,但也可以不用。
例:
select GROUP_CONCAT(pct_id) as pct_ids from (select max(pct_id) as pct_id from potential_customer_trail GROUP BY pc_id HAVING count(pct_id)>1 LIMIT 10) as a

原文地址:https://www.cnblogs.com/chy1000/p/3447277.html