快速删除ORACLE重复记录

*通过创建临时表来实现

create table temp_emp as (select distinct * from employee)
  
truncate table employee; (清空employee表的数据）

insert into employee select * from temp_emp;

*通过rowid来实现

delete from employee where rowid not in ( 
select max(t1.rowid) from employee t1 group by t1.emp_id,t1.emp_name,t1.salary);