SQLite DB: duplicate Record created at modified time

[Jean-Yves_Pochez]

Suppresion dans sqlite

[code]It’s easy to find duplicates with one field: SELECT name, COUNT(email) FROM users GROUP BY email HAVING ( COUNT(email) > 1 ) So if we have a table ID NAME EMAIL 1 John asd@asd.com 2 Sam asd@asd.com 3 Tom asd@asd.com 4 Bob bob@asd.com 5 Tom asd@asd.com This query will give us John, Sam, Tom, Tom because they all have the same email. However, what I want is to get duplicates with the same email and name. try this: declare @YourTable table (id …