日期:2014-05-16 浏览次数:20710 次
在项目中有一个数据表出现了重复的数据需要把它查询出来找一下是哪里出了问题: SELECT flux.* FROM flux,( SELECT web_address,web_ip FROM flux GROUP BY web_address,web_ip HAVING COUNT(1) > 1 ) AS nick WHERE flux.web_address = nick.web_address AND flux.web_ip=nick.web_ip