Simple, fast and good:

DELETE
FROM MyTableWithDuplicates
WHERE
rowid not in
(
SELECT min(ROWID)
FROM MyTableWithDuplicates
GROUP BY Col1, Col2, Col3  --you may enter all columns here you want to check.
);