天天看點

SQL 去重

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)

繼續閱讀