ORACLE查询删除重复记录

delete table_name
where rowid not in (
select max(rowid) from table_name group t by t.param,t.param
);

现查找表中按不同字段group后的结果,选取rowid最大的,删除剩余的.