delete from tabname t1
where rowid <> (select min(rowid)
from tabname t2
where t1.col_name = t2.col_name
and t1.id = t2.id);
delete from tabname t1
where rowid <> (select min(rowid)
from tabname t2
where t1.col_name = t2.col_name
and t1.id = t2.id);