Deleted rows duplications in MSSQLsever

WITH CTE AS(
   SELECT N,asofdate,
       RN = ROW_NUMBER()OVER(PARTITION BY N ORDER BY N)
   FROM dbo.CSVCBC08TO0214 where asofdate='31012014'
)
DELETE FROM CTE WHERE RN > 1