创建临时表

create table pic_temp as 
select  b.scs_id,b.rowid as dataid from ods_smis_scs_pic b where b.rowid not in (select MAX(a.ROWID) dataid from ods_smis_scs_pic a GROUP BY a.scs_id); 

删除重复数据

delete from ods_smis_scs_pic a where a.rowid in (select b.dataid from pic_temp b); 

commit;

删除临时表

drop table pic_temp

---