ORACLE删除重复数据

ORACLE删除重复数据

1. -- 删除重复数据
2. delete from t_day_imp
3. where rowid not in(
4.    select max(rowid) from t_day_imp
5.    group by riqi,tcity,carrier,version,platform
6. );
7. commit;
8. -- 创建唯一索引
9. create unique index udx_day_imp on t_day_imp(riqi,tcity,carrier,version,platform);