oracle 同样数据删除(仅仅留一条)

DELETE
　　FROM reg_user t1
　　WHERE user_name='9527008' and rowid > ( SELECT min(rowid)
　　FROM location t2
　　WHERE t1.user_name= t2.user_name);