Delete duplicate rows in SQL

delete from
  table_name A
where
  a.rowid >
  any (
    select B.rowid
    from table_name B
    where A.column_name = B.column_name
  );