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); posted on 2014-12-02 15:37 蓝水域 阅读( ...) 评论( ...) 编辑 收藏 转载于:https://www.cnblogs.com/lucky110100/p/4137603.html