This one worked for me

delete from table where id in (select id from (select row_number() over(partition by id) as row, a.id from table a) as alias where row!=1);