In oracle, some data is exactly the same. To clear duplicate data, only one non-duplicate data is retained. Thank you for providing the second deduplication SQL statement. This may be faster. Oracledeletetable1whererowidnotin (selectmax (rowid) fromtable1groupbycol1, col2) DELETEtablesWHEREr
In oracle, some data is exactly the same. To clear duplicate data, only one non-duplicate data is retained. Thank you for providing the second deduplication SQL statement. This may be faster. Oracle delete table1 where rowid not in (select max (rowid) from table1 group by col1, col2) DELETE table sWHERE r
In oracle, some data is exactly the same. To clear duplicate data, only one non-duplicate data is retained.
Thank you.
Liu xianhuiThe second deduplicated SQL statement provided. This may be faster.
Oracle
delete table1 where rowid not in (select max(rowid) from table1 group by col1 ,col2 )
DELETE table sWHERE rowid < (SELECT MAX(rowid) FROM table q WHERE q.name = s.name)