Delete duplicate records in sql

 WITH CTE AS(

   SELECT [col1], [col2], [col3], [col4], 
       ROW_NUMBER()OVER(PARTITION BY col1 ORDER BY col1) as RN
   FROM dbo.Table1
)
DELETE FROM CTE WHERE RN > 1