类型：转载 责任编辑：asp.net 日期：2007/05/23
热门软件下载：
如何删除同一个表中的重复记录。但不是全部删除掉。留下一条
网友回答：
用臨時表過渡數據
select distinct * into tab from tb
delete from tb
insert into tb select * from tab
drop table tab
delete from table1 a where id not in (select max(id) from table1 group by name)
删除name重复的记录，只保留id最小的
DELETE a FROM T1 AS a
WHERE EXISTS(SELECT 1 FROM T1 AS b WHERE a.Name = b.Name AND a.ID < b.ID)
select distinct * into 临时表 from 表名
delete from 表名
insert into 表名 select * from 临时表
关于此话题请参考
http://www.yesky.com/SoftChannel/72342371928965120/20041021/1867019.shtml