基于MySQL的如何查询重复数据方法

在项目中有一个数据表出现了重复的数据需要把它查询出来找一下是哪里出了问题：SELECT flux.*FROM flux,(  SELECT web_address,web_ip  FROM flux  GROUP BY web_address,web_ip  HAVING COUNT(1) > 1) AS nickWHERE flux.web_address = nick.web_address  AND flux.web_ip=nick.web_ip