如何刪除oracle數(shù)據(jù)庫(kù)中的重復(fù)記錄？delete from GXS_VIEW_PATIENT_INFO where rowid not in (select min(rowid) from GXS

如何刪除oracle數(shù)據(jù)庫(kù)中的重復(fù)記錄？

delete from GXS_VIEW_PATIENT_INFO where rowid not in (select min(rowid) from GXS_VIEW_PATIENT_INFO group by 某字段) 某字段就是按照某幾個(gè)分組 比如數(shù)據(jù)id name1 a1 a1 a 你最后group by id或者group by name都可以但是如果 id name1 a1 a1 a2 a但是像上邊這樣，最后也只能保留一條，所以你得找到一個(gè)group by 的字段 不過這個(gè)慎用，數(shù)據(jù)多的時(shí)候會(huì)很慢的，刪除前備份一下數(shù)據(jù)吧