SQL删除重复列 [回钦波]

在这里我做个SQL删除重复列实例，create table test(
   id     number(4) primary key not null,
   name   varchar(6),
   age    number(5,2) check(age between 0 and 150)
);
insert into test(id,name,age) values(1,'回钦波',25);
insert into test(id,name,age) values(2,'回钦波',25);
insert into test(id,name,age) values(3,'在测试',20);
delete from test where name in(select name from test where name in(select name from test group by name having count(name)>1)) and id =(select max(id) from test group by name having count(name)>1);

select * from test;

更多交流、更多了解：QQ:444084929 [回钦波] 个人主页：http://www.yezhong.net