oracle中刪除重復(fù)記錄(專業(yè)版)
【正文】 *error at line 1:ora02299: cannot validate () duplicate keys foundsqlcreate table dups as select * from cz where rowid in (select row_id from exceptions)。 c1 c10 c20 1 2 dsf 1 2 dsf 1 2 dsf 1 2 dsf 2 3 che 1 2 dsf 1 2 dsf 1 2 dsf 1 2 dsf 2 3 che 2 3 che 2 3 che 2 3 che 3 4 dff 3 4 dff 3 4 dff 4 5 err 5 3 dar 6 1 wee 7 2 zxc20 rows selected.：(1).sqlselect * from cz group by c1,c10,c20 having count(*) 1。(2).適用于有少量重復(fù)記錄的情況(注意，對于有大量重復(fù)記錄的情況，用以下語句效率會(huì)非常低)：sqldelete from cz a where !=(select max(rowid) from cz b where = and = and =)。3 rows created.sqlselect *from cz。 (再將臨時(shí)表test里的
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1