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