DELETE T
FROM
(
SELECT *
, DupRank = ROW_NUMBER() OVER (
              PARTITION BY Cod
              ORDER BY (SELECT NULL)
            )
FROM tblproduto
) AS T
WHERE DupRank > 1 
