Oracle 表中按一个字段去除重复记录

 表 tb_test

 id  varchar2(20);

name varchar2(20);

age number;

 select * from tb_test;

只按name 重复的保留一条记录

select * from tb_test t1 where
 exists(
   select 1 from tb_test t2 where t1.name=t2.name group by t2.name having max(t2.rowid)=t1.rowid)

 

转载于:https://blog.51cto.com/4389218/777598