Delete Duplicate SQL Records

by

I got it! Simple and it worked great.

delete 
   t1 
from 
   tTable t1, tTable t2 
where 
   t1.locationName = t2.locationName and  
   t1.id > t2.id

http://www.cryer.co.uk/brian/sql/sql_delete_duplicates.htm

More Related Contents:

  1. Finding duplicate values in a SQL table
  2. How do I (or can I) SELECT DISTINCT on multiple columns?
  3. How to delete duplicate rows in SQL Server?
  4. Removing duplicate rows from table in Oracle
  5. Delete duplicate records in SQL Server?
  6. How to delete duplicate rows without unique identifier
  7. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  8. MySQL remove duplicates from big database quick
  9. Finding duplicate rows in SQL Server
  10. How do I find duplicates across multiple columns?
  11. Find duplicate rows with PostgreSQL
  12. How to select records without duplicate on just one field in SQL?
  13. Left Join without duplicate rows from left table
  14. How to bulk insert only new rows in PostreSQL
  15. Removing duplicate rows (based on values from multiple columns) from SQL table
  16. SQL Query output in VBA is different than in SQL Oracle
  17. How do I escape a single quote in SQL Server?
  18. Selecting data from two different servers in SQL Server
  19. PostgreSQL: running count of rows for a query ‘by minute’
  20. What is the difference between HAVING and WHERE in SQL?
  21. How to delete duplicate entries?
  22. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  23. SQL Server: Howto get foreign key reference from information_schema?
  24. Database EAV Pros/Cons and Alternatives
  25. Can a stored procedure/function return a table?
  26. sqlplus statement from command line
  27. Naming of ID columns in database tables
  28. How to insert a string which contains an “&”
  29. Subtracting Dates in Oracle – Number or Interval Datatype?
  30. Why are aggregate functions not allowed in where clause

Leave a Comment