查询重复手机号

SELECTuser_mobile 
FROM`t_user` 
GROUP BYuser_mobile 
HAVINGCOUNT( user_mobile ) > 1;

 

查询重复的手机号及数量

SELECTuser_mobile,COUNT(*) AS count 
FROM`t_user` 
GROUP BYuser_mobile
HAVINGcount > 1;

查询所有重复的手机号的详细信息

SELECT* 
FROMt_user 
WHEREuser_mobile IN ( SELECT user_mobile FROM `t_user` GROUP BY user_mobile HAVING COUNT( user_mobile ) > 1 );