22,300
社区成员




SET NOCOUNT ON
create table #temp_001(
ID INT,
F1 VARCHAR(10),
F2 VARCHAR(10),
F3 VARCHAR(10),
F4 VARCHAR(10))
INSERT INTO #temp_001
SELECT 1,'A','B','C','D' UNION ALL
SELECT 2,'A','B','C','D' UNION ALL
SELECT 3,'A','B','C','D' UNION ALL
SELECT 4,'A','B','C','D' UNION ALL
SELECT 5,'A','B','C','D' UNION ALL
SELECT 6,'A','B','C','D' UNION ALL
SELECT 7,'AA','BA','CA','DA' UNION ALL
SELECT 8,'AA','BA','CA','DA' UNION ALL
SELECT 9,'AA','BA','CA','DA' UNION ALL
SELECT 10,'AA','BA','CA','DA' UNION ALL
SELECT 11,'AA','BA','CA','DA' UNION ALL
SELECT 12,'AA','BA','CA','DA'
DELETE FROM #temp_001
WHERE ID <>(SELECT MIN(ID) FROM #temp_001 A WHERE A.F1=#temp_001.F1 AND A.F2=#temp_001.F2 AND A.F3=#temp_001.F3 AND A.F4 =#temp_001.F4 )
SELECT * FROM #temp_001
DROP TABLE #temp_001
/*
ID F1 F2 F3 F4
----------- ---------- ---------- ---------- ----------
1 A B C D
7 AA BA CA DA
*/