oracle去掉重复行
oracle 删除重复行
有表：  
create table t_test1(  
   id        number,  
   name      varchar2(50),  
   age       number,  
   birthday  date 
);  
1、选择出重复的行  
select a.* from t_test1 a  
where rowid <> (select max(rowid)  
                   from t_test1 b  
                  where a.id = b.id  -- where语句后面的条件是你定义重复的规则  
                    and a.name = b.name 
                    and a.age = b.age  
                    and a.birthday = b.birthday);  
 
2、删除重复的行  
delete from t_test1 a  
where rowid <> (select max(rowid)  
                   from t_test1 b  
                  where a.id = b.id  
                    and a.name = b.name 
                    and a.age = b.age  
                    and a.birthday = b.birthday);