Deleting duplicate rows from sqlite database

by

You need a way to distinguish the rows. Based on your comment, you could use the special rowid column for that.

To delete duplicates by keeping the lowest rowid per (hash,d):

delete   from YourTable
where    rowid not in
         (
         select  min(rowid)
         from    YourTable
         group by
                 hash
         ,       d
         )

More Related Contents:

  1. How can I list the tables in a SQLite database file that was opened with ATTACH?
  2. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  3. SQLite – How do you join tables from different databases?
  4. Does SQLite3 not support foreign key constraints?
  5. SQLite – ORDER BY RAND()
  6. How to get a list of column names on Sqlite3 database?
  7. Drop all tables command
  8. Core Data Performance with Single Parent Entity
  9. Android multiple databases open
  10. sqlite select with condition on date
  11. SQLite3 UNIQUE constraint failed error
  12. Copy table structure to new table in sqlite3
  13. In MySQL queries, why use join instead of where?
  14. Transpose latest rows per user to columns
  15. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  16. Splitting the string in sql server
  17. Need to list all triggers in SQL Server database with table name and table’s schema
  18. What is the purpose of constraint naming
  19. How to create timestamp column with default value ‘now’?
  20. INSERT COMMAND :: ERROR: column “value” does not exist
  21. Comma separated values in a database field
  22. Unfindable SQLite Syntax Error
  23. Can SQL Server Express LocalDB be connected to remotely?
  24. What can cause an Oracle ROWID to change?
  25. SQL: Using NULL values vs. default values
  26. Why don’t DBMS’s support ASSERTION
  27. What is the best way to implement soft deletion?
  28. PostgreSQL how to create a copy of a database or schema?
  29. Historical / auditable database
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment