ORACLE删除重复记录

delete from tablename where id not in (select max(id) from tablename group by col1,col2,...)