Deleting duplicate rows in SQL Server

WITH TableDup AS

(

  SELECT *,

    ROW_NUMBER() OVER( ORDER BY IDCol) AS RN_col

  FROM dbo.TableSource

)

DELETE FROM TableDup WHERE RN_col > 1;