Remove Duplicate in sql table using CTE

With CTE AS( Select fielddefid ,Row_number() over(partition by fielddefid order by fielddefid)DUP from fielddefs )Delete from CTE where DUP >1