delete from tbl_a a where a.a_name in (select b.a_name from tbl_a b group by b.a_name having count(b.a_name)>1) and rowid not in (select min(rowid) from tbl_a c group by c.a_name having count(*)>1);
如对本文有疑问, 点击进行留言回复!!
Oracle 基本概念 Dadabase,schema,user,table...
dbeaver连接Oracle中文乱码的解决方案--druid
Oracle常用语句(时间格式、去重、去特殊符号、查询表空间等)
Navicate 如何导出数据库中的存储过程、事件、视图等?
网友评论