求急，删除重复的id号记录，只保留一条记录？在线等代！

[chengxing]

表的结构如下：

ID NewCode PartName Kind
---------------------------------------------
14 A332-PCUBOCSR-HT HT-8008SR ASSM
14 A332-PCUBOCSR-HT HT-8008SR ASSM
15 A332-PCUBOCSR HT-8008SF DIP
15 A332-PCUBOCSR HT-8008SF DIP

?1.删除整个表中重复的ID号记录，只保留一条记录。该如何实现！谢谢！
例如：id重复的14记录有两条，现在只保留一条在表中，该如可实现？

求急!在线等代!谢谢！

[gzhughie]

Yang_(扬帆破浪) 的方法好，只是有点错误 应该是

SELECT ID,MIN(NewCode) AS NewCode,MIN(PartName) AS PartName,MIN(Kind) AS Kind
INTO TEMPTABLE
FROM TABLENAME
GROUP BY ID

TRUNCATE TABLE TABLENAME

INSERT TABLENAME
SELECT * FROM TEMPTABLE

DROP TABLE TEMPTABLE

[Yang_]

你的数据完全一样？

SELECT ID,MIN(NewCode) AS NewCode,MIN(PartName) AS PartName,MIN(Kind) AS Kind
INTO TEMPTABLE
FROM TABLENAME

TRUNCATE TABLE TABLENAME

INSERT TABLENAME
SELECT * FROM TEMPTABLE

DROP TABLE TEMPTABLE

[given]

select distinct * into #temp from table
delete from table
insert into table select * from #temp
drop table #temp

[chengxing]

to Yang_(扬帆破浪):你好！我这里就是要删除id号相同的，只保留一条，别的字段相同不管，表中只允许id号没有相同的，并且仅有一条.

[Chiff]

同意given(andy)

[given]

select ID,min(NewCode),min(PartName),min(Kind) into #temp from table group by xtype having count(xtype)>=2

delete from table
insert into table select * from #temp
drop table #temp

[given]

上面有错：
更正如下：

select ID,min(NewCode),min(PartName),min(Kind) into #temp from table group by id having count(id)>=2
insert into #temp select * from table where id not in (select id from #temp)
delete from table
insert into table select * from #temp
drop table #temp

[AWP365]

加入一个自动增加的列（identity）id_1
delete from tablename where id_1 not in (select min(id_1) from tablename group by id )