seq去除重复数据

DELETE FROM temp_fjh_2 a WHERE a.rowid!=(SELECT MAX(b.rowid) FROM temp_fjh_2 b WHERE a.a=b.a);

表名和列名换一下，执行时就会删除重复列。