For deleting the Duplicate rows from table in sql server 2005

WITH CTE (column1,column2, DuplicateCount)
AS
(
SELECT column1,column2,
ROW_NUMBER() OVER(PARTITION BY column1,column2 ORDER BY column1) AS DuplicateCount
FROM tablename
)
DELETE
FROM CTE
WHERE DuplicateCount > 1
GO