MySQL 查询重复数据

SQL

• 查询哪些字段，重复了多少次

SELECT name , COUNT(name) from user2 GROUP BY `name` 

• 查询哪些字段，重复了2次以上

SELECT name , COUNT(name) from user2 GROUP BY `name` HAVING COUNT(`name`) > 1

• 查询分别是哪几条记录重复了2次以上

SELECT * from user2 WHERE `name` in (
SELECT name from user2 GROUP BY `name` HAVING COUNT(`name`) > 1
)