How to remove duplicate rows except one?

On mytable no column is primary :

What I want :

This does not work :

DELETE FROM
   mytable
WHERE
   Name NOT IN (
      SELECT
         MAX(Name)
      FROM
         mytable
      GROUP BY
         Company
   )
;

Without new table creation and no CTE, how can I remove duplicate rows except one?