DELETE

　　FROM reg_user t1

　　WHERE user_name='9527008' and rowid > ( SELECT min(rowid)

　　FROM location t2

　　WHERE t1.user_name= t2.user_name);