MySQL 查询表中重复数据_mysql 查询电话号码重复的数据

作者：Cpp五条 | 2024-03-14 10:57:15

踩

mysql 查询电话号码重复的数据

查询重复手机号


SELECT
	user_mobile 
FROM
	`t_user` 
GROUP BY
	user_mobile 
HAVING
	COUNT( user_mobile ) > 1;

查询重复的手机号及数量


SELECT
	user_mobile,
	COUNT(*) AS count 
FROM
	`t_user` 
GROUP BY
	user_mobile
HAVING
	count > 1;

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


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

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/233679