sql 去重
时间:2022-03-14 16:56
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)
SQL 去重,布布扣,bubuko.com