去除表中的重复 记录（多字段）

题目：删除多字段重复的表中的重复记录，同样的记录只显示一条。
create table T_TEMP
(
ID NUMBER,
NAME VARCHAR2(15),
TEL VARCHAR2(11)
);
insert into T_TEMP(ID, NAME, TEL)values (1, A', '1');
insert into T_TEMP(ID, NAME, TEL)values (2, 'A', '11');
insert into T_TEMP(ID, NAME, TEL)values (3, 'B', '111');
insert into T_TEMP(ID, NAME, TEL)values (4, 'C', '131');

insert into T_TEMP(ID, NAME, TEL)values (5, 'D', '138');

参考答案： delete from T_TEMP where id not in(select
min(id) from T_TEMP group by name,tel);