You could use something like this:
FROM your_table t
WHERE id = t.id
AND rowid < t.rowid);
In this example ‘id’ would be the field used to identify duplicates.
I used rowid to decide what record to keep in the table, but you could use any other field(s) as needed.