DELETE FROM YOURTABLENAME WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM YOURTABLENAME GROUP BY &COLUMN_NAME);