delete from testtable a where (a.testcontent) in (select testcontent from testtable GROUP BY testcontent having count(*)>1) and seqid not in (select min(seqid) from testtable group by testcontent having count(*)>1)
本文共 262 字，大约阅读时间需要 1 分钟。
delete from testtable a where (a.testcontent) in (select testcontent from testtable GROUP BY testcontent having count(*)>1) and seqid not in (select min(seqid) from testtable group by testcontent having count(*)>1)
转载于:https://blog.51cto.com/smilezhuolin/1405987