Apagar duplicados

from: http://www.devx.com/tips/Tip/14665

DELETE FROM our_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY column1, column2, column3... ;