oracle 如何删除重复记录

delete from test where phonenumber in(select phonenumber from test group by phonenumber having count(phonenumber) >1)and rowid not in(select min(rowid) from test group by phonenumber having count(phonenumber) >1)