delete duplicate rows

WITH CTE AS
(
SELECT *,ROW_NUMBER() OVER (PARTITION BY [TagID],[TemplateID] ORDER BY  [TagID],[TemplateID]) AS RN
FROM [TPDocCore].[TagTemplatexRef]
)

DELETE FROM CTE WHERE RN<>1