删除关系数据库的重复项(小技巧)

 

DELETE FROM TB_Test WHERE ID NOT IN
(
SELECT MIN(ID ) AS MinID FROM dbo.TB_Test AS tt GROUP BY CustomInfo
)

留第一条还是最后一条看着办，sql2005中ID能用行号(RowID)了