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

posted @ 2013-11-28 10:58  chy1000  阅读(167)  评论(0编辑  收藏  举报