ORACLE删除重复数据 ORACLE删除重复数据 -- 删除重复数据 delete from t_day_imp where rowid not in( select max(rowid) from t_day_imp group by riqi,tcity,carrier,version,platform ); commit; -- 创建唯一索引 create unique index udx_day_imp on t_day_imp(riqi,tcity,carrier,version,platform);