Oracle删除多字段重复数据，只保留一条记录

delete from user_INFO a where (a.age,a.sex) in (select age，sex group by age，sex having count(*) > 1) and rowid not in (select min(rowid) from user_INFO group by age，sex having count(*)>1);