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