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本文共 248 字，大约阅读时间需要 1 分钟。
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