SQLite: Remove duplicate rows

--  Identify duplicate rows
SELECT MIN(ROWID) FROM all_chems GROUP BY cas_number;

-- Remove duplicates
DELETE FROM all_chems WHERE ROWID NOT IN (
	SELECT MIN(ROWID)
	FROM all_chems
	GROUP BY cas_number
	);