根据两个或者更多字段清除重复数据

当重复记录是通过两个或更多字段判断时&＃xff0c;可按下述方法处理&＃xff1a;

USE [DBName]
DROP TABLE [#TmpTABLE]
DROP TABLE [#TmpTABLE2]
DROP TABLE [NEWTABLE]
SELECT IDENTITY(int, 1, 1) as [AutoID], * INTO [#TmpTABLE] FROM [ORGTABLE]
SELECT MIN([AutoID]) AS [AutoID] INTO [#TmpTABLE2] FROM [#TmpTABLE] GROUP BY [FIELD1], [FIELD2]… /*用于判断的字段列表*/
SELECT [FieldList] /*字段列表&＃xff0c;不包括用于索引的AutoID*/ INTO [NEWTABLE] FROM [#TmpTABLE] WHERE [AutoID] IN (SELECT [AutoID] FROM [#TmpTABLE2])
EXEC sp_rename &＃39;ORGTABLE&＃39;, &＃39;ORGTABLEBAK&＃39;
EXEC sp_rename &＃39;NEWTABLE&＃39;, &＃39;ORGTABLE&＃39;