lauhin
10/15/2019 - 6:34 PM

Delete duplicate rows in SQL

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
  );