Delete duplicate rows (don’t delete all duplicate)

by

Try the steps described in this article: Removing duplicates from a PostgreSQL database.

It describes a situation when you have to deal with huge amount of data which isn’t possible to group by.

A simple solution would be this:

DELETE FROM foo
       WHERE id NOT IN (SELECT min(id) --or max(id)
                        FROM foo
                        GROUP BY hash)

Where hash is something that gets duplicated.

More Related Contents:

  1. How to delete duplicate entries?
  2. Get the distinct sum of a joined table column
  3. PostgreSQL “Column does not exist” but it actually does
  4. Is SELECT or INSERT in a function prone to race conditions?
  5. Any downsides of using data type “text” for storing strings?
  6. Index for finding an element in a JSON array
  7. Query for array elements inside JSON type
  8. Calculating Cumulative Sum in PostgreSQL
  9. Best way to check for “empty or null value”
  10. How to avoid multiple function evals with the (func()).* syntax in a query?
  11. Time zone storage in data type “timestamp with time zone”
  12. Is there something like a zip() function in PostgreSQL that combines two arrays?
  13. Serial numbers per group of rows for compound key
  14. PostgreSQL parameterized Order By / Limit in table function
  15. Postgres analogue to CROSS APPLY in SQL Server
  16. Get the default values of table columns in Postgres?
  17. Division of integers returns 0
  18. PostgreSQL: how to convert from Unix epoch to date?
  19. Postgres not using index when index scan is much better option
  20. Postgres – Function to return the intersection of 2 ARRAYs?
  21. How to store array or multiple values in one column
  22. convert Postgres geometry format to WKT
  23. Which datatype should be used for currency?
  24. How to return two columns with function
  25. Count cumulative total in Postgresql
  26. Prepared Statement on Postgresql in Rails
  27. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  28. Postgresql query between date ranges
  29. How to use SQL LIKE condition with multiple values in PostgreSQL?
  30. Is there a postgres CLOSEST operator?

Leave a Comment