【正文】
:數(shù)據(jù)庫中有deny_mobile表需要按照 mobile去重復,刪除重復記錄為: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 COUNT(*)1)6 / 6。3 rows created.sqlselect *from cz。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)。 table created.sqlselect * from dups。具體步驟如下:sql?/rdbms/admin/table created.sqldesc exceptions name null? type row_id rowid owner varchar2(30) table_name