本文共 197 字,大约阅读时间需要 1 分钟。
统计重复的手机号吗
select * from (select count(mobile) as c, mobile from member where length(mobile) >= 11 group by mobile) as m where m.c > 1;