oracle中刪除重復(fù)記錄(文件)
【正文】 null? type row_id rowid owner varchar2(30) table_name varchar2(30) constraint varchar2(30)sqlalter table cz add constraint cz_unique unique(c1,c10,c20) exceptions into exceptions。row_idaaahd/aaiaaaadsaaaaaahd/aaiaaaadsaabaaahd/aaiaaaadsaacaaahd/aaiaaaadsaafaaahd/aaiaaaadsaahaaahd/aaiaaaadsaaiaaahd/aaiaaaadsaagaaahd/aaiaaaadsaadaaahd/aaiaaaadsaaeaaahd/aaiaaaadsaajaaahd/aaiaaaadsaakaaahd/aaiaaaadsaalaaahd/aaiaaaadsaamaaahd/aaiaaaadsaanaaahd/aaiaaaadsaaoaaahd/aaiaaaadsaap16 rows selected.sqldelete from cz where rowid in ( select row_id from exceptions)。：數(shù)據(jù)庫(kù)中有deny_mobile表需要按照 mobile去重復(fù)，刪除重復(fù)記錄為：Delete from SMS_DENYMOBILE WHERE mobile IN (SELECT mobile FROM SMS_DENYMOBILE GROUP BY mobile HAVING COUNT(*)1)AND ROWID NOT IN (SELECT MIN(ROWID) FROM SMS_DENYMOBILE GROUP BY mobile HAVING
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1