>FIELD1 FIELD2 >1 Entry ABC >1 Entry ABC >2 Entry 123 >2 Entry 123 >>
DECLARE @TEst TABLE (FIELD1 int, FIELD2 char(10)) INSERT INTO @Test VALUES (1,'Entry ABC') INSERT INTO @Test VALUES (1,'Entry ABC') INSERT INTO @Test VALUES (2,'Entry 123') INSERT INTO @Test VALUES (2,'Entry 123') ;with cteTest AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY Field1, Field1 ORDER BY Field1, Field1) AS R_C FROM @TEst Test ) DELETE FROM cteTest WHERE R_C > 1 SELECT * FROM @TEst