delete relation1 from relation1,relation1 as b where relation1.c1>relation1.c2 and relation1.c1=b.c2 and relation1.c2=b.c1;