How to delete duplicate rows with SQL?

by 
DELETE FROM table WHERE id NOT IN
    (SELECT MAX(id) FROM table GROUP BY date);

More Related Contents:

  1. Split data of columns in (if of is not null data of is null) [closed]
  2. SQL Sum of Field [closed]
  3. SQL Data models
  4. How to request a random row in SQL?
  5. What is the difference between UNION and UNION ALL?
  6. Select First Row of Every Group in sql [duplicate]
  7. Comparing Dates in Oracle SQL
  8. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  9. How to use (install) dblink in PostgreSQL?
  10. How to design a database for User Defined Fields?
  11. What is the difference between function and procedure in PL/SQL?
  12. How to check the maximum number of allowed connections to an Oracle database?
  13. Count Number of Consecutive Occurrence of values in Table
  14. get next sequence value from database using hibernate
  15. New line in Sql Query
  16. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  17. How can I compare time in SQL Server?
  18. How to do IF NOT EXISTS in SQLite
  19. SELECT from table with Varying IN list in WHERE clause
  20. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  21. Does Postgres support nested or autonomous transactions?
  22. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  23. alternatives to REPLACE on a text or ntext datatype
  24. Update a column of a table with a column of another table in PostgreSQL
  25. ORA-00972 identifier is too long alias column name
  26. Check if NULL exists in Postgres array
  27. SQL Server equivalent of WM_CONCAT function [duplicate]
  28. Distributed transaction error?
  29. Determine what user created objects in SQL Server
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment