去除数据表中重复行&oracle 替换数据

来源:互联网 发布:cpa广告联盟源码 编辑:程序博客网 时间:2024/04/28 12:27

delete from table1 t1 where rowid <(select max(rowid) from table1  t2 where  t1.id = t2.id) 


UPDATE  S_USER t1 set t1.user_name = replace(t1.user_name,'21e','21w')

0 0