全部博文
-
编辑 删除
Oracle数据库删除表中重复记录的方法
1、 delete from tb_channel a where a.rowid in (select max(b.rowid) from tb_channle b where a.policyno=b.policyno and a.classcode=b.classcode); 2、建立临时表、清空原表、插回原表，如下： create table temp_emp as (select distinct * from employee) ; truncate table employee; insert into employee select * from temp_emp;
