delete from table where id not in( select id from table group by column1, column2 having
count(column1) > 1 and count(column2) >1);
delete from table where id not in( select id from table group by column1, column2 having
count(column1) > 1 and count(column2) >1);