求SQL语句

[LamLam]

求SQL语句
删除TABLE里面相同的多余记录
只保留唯一一条
比如
1,A
1,A
1,A
2,B

删除两个多余相同的1,A
最后保留
1,A
2,B
谢谢!!

[guasha]

select distinct ??
into #temp
from table

delete table

insert into table
select * from #temp

[panther_totem]

select distinct * into table2 from table1;
drop table table1;
select * into table1 from table2;
drop table table2;

最老土的办法。

[panther_totem]

我还写错了：
select distinct * into table2 from table1;
delete table1;
insert into table1 select * from table2;
drop table table2;

[panther_totem]

强烈建议：用guasha(刮痧)的
select distinct * into #temp from table

delete table

insert into table select * from #temp

[LamLam]

谢谢大家!! :)