try this -

[sql]delete from table_name
where column_name1 in
( select e.column_name1
from table_name e, table_name f
where e.column_name1 =f.column_name1 and
e.column_name2=f.column_name2 )[/sql]