Mysql 查询重复数据

SELECT * FROM 表名 WHERE (name_add,address)
IN ( SELECT name_add,address FROM 表名 GROUP BY name_add,address HAVING COUNT(1) > 1);