Selecionando e deletando registro duplicados

WITH TableWithRowID AS
(
 SELECT ROW_NUMBER() OVER (PARTITION BY ORDER BY ) AS RowID, 
  FROM
)
DELETE o
FROM TableWithRowID o
WHERE RowID > 1

Fonte:
https://www.mssqltips.com/sqlservertip/4486/find-and-remove-duplicate-rows-from-a-sql-server-table/