CREATE TABLE tf_user(
ID NUMBER(14),
NAME VARCHAR2(255),
email VARCHAR2(255)
);

Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (1, 'chengwei', 'chengwei@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (2, 'lizm', 'lizm@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (3, 'changhj', 'changhj@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (4, 'wujun', 'wujun@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (5, 'mmtye', 'mmtye@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (6, 'guona', 'guona@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (7, 'chengwei', 'chengwei@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (8, 'guona', 'guona@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (9, 'mmtye', 'mmtye@tencent.com.cn');
Insert into TF_USER
 (ID, NAME, EMAIL)
 Values
 (10, 'chengwei', 'chengwei@tencent.com.cn');


-- 一条语句删除name重复的记录
DELETE FROM tf_user WHERE ROWID NOT IN(
SELECT b.rod from (
SELECT MIN(ROWID) rod, NAME FROM tf_user a
GROUP BY NAME) b);

SELECT * from tf_user;