DELETE FROM reg_user t1 WHERE user_name='9527008' and rowid > ( SELECT min(rowid) FROM location t2 WHERE t1.user_name= t2.user_name);
oracle 同样数据删除(仅仅留一条)
原文：http://www.cnblogs.com/zfyouxi/p/4011880.html
