本文共 150 字，大约阅读时间需要 1 分钟。

SELECT * from (

select GROUP_CONCAT(uid) as uids, phone , count(phone) as phones  from user where show=1  GROUP BY phone HAVING count(phone)>=2

) as tmp

转载地址：http://uykmf.baihongyu.com/