分享一个SQL删除重复内容的方法

wgs7909

DELETE from goods where id in ( select id from (SELECT id, count(jan) as cnt from goods group by jan HAVING cnt>1) as t1)
这个语句，多运行几次 ，直到影响的行数为0，就可以把 jan列中重复的全部删除。

迷茫...

SELECT id, count(jan) as cnt from goods group by jan HAVING cnt>1
这一段能查id?

wgs7909

迷茫... 发表于 2016-12-20 09:47
SELECT id, count(jan) as cnt from goods group by jan HAVING cnt>1
这一段能查id?

这一段查询所有的jan字段有重复的行的id