SQL语句 - 删除表中指定列重复的纪录

 

 

SELECT identity(int,1,1) AS id, * INTO #temp FROM MyTable
go
DELETE #temp WHERE id NOT IN (SELECT MAX(id) FROM #temp GROUP BY Word)
go
DELETE MyTable
go
INSERT INTO MyTable SELECT Code,Word,Acceptation,TimeCollect from #temp
go