WITH CTES(COl1,Col2, DuplicateCount)
AS
(
SELECT COl1,Col2,
ROW_NUMBER()
OVER(PARTITION BY COl1,Col2 ORDER BY Col1) AS DuplicateCount
FROM @DuplicateRcordTable
)
DELETE
FROM CTES
WHERE DuplicateCount > 1