Source: cirosantilli/delete-all-duplicate-rows-in-sql

= Delete all duplicate rows in SQL

* <SQLite> with `rowid`: https://stackoverflow.com/questions/8190541/deleting-duplicate-rows-from-sqlite-database
  * <PostgreSQL> is `ctid`: https://stackoverflow.com/questions/14626481/rowid-equivalent-in-postgres-9-2
* <SQL Server> has crazy "CTEs" change backing table extension: https://stackoverflow.com/questions/18390574/how-to-delete-duplicate-rows-in-sql-server

Back to article page