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://blog.csdn.net/without0815/article/details/39053463
