Código SQL:
Ver originalCREATE TABLE #temp(
id INT,
campo1 INT,
campo2 INT,
campo3 INT
)
INSERT INTO #temp VALUES (10, 200, 3000, 4000)
INSERT INTO #temp VALUES (10, 200, 3000, 4000)
INSERT INTO #temp VALUES (10, 200, 3000, 4000)
INSERT INTO #temp VALUES (11, 200, 3000, 4000)
INSERT INTO #temp VALUES (32, 500, 4000, 6000)
INSERT INTO #temp VALUES (32, 500, 4000, 6000)
INSERT INTO #temp VALUES (33, 500, 4000, 6000)
INSERT INTO #temp VALUES (21, 500, 4000, 6000)
INSERT INTO #temp VALUES (21, 500, 4000, 6000)
INSERT INTO #temp VALUES (22, 500, 4000, 6000)
SELECT COUNT(*) AS NUMBER,id,campo1 FROM #temp GROUP BY id,campo1 HAVING COUNT(*)=1
Resultado:
number id campo1
1 11 200
1 22 500
1 33 500