This is even faster, on a tiny table: SELECT n1, n2 FROM table1 INTERSECT SELECT n2, n1 FROM table1 WHERE n2<n1;
Moreover, the original query does not give the desired result - in the example table, 2,4 is also returned. Of course, there remains the question as to why your UNION query seems to have hung... Tom -----Original Message----- From: Jim Morris Did you try to time a simpler select: SELECT min(n1, n2) as new1, max(n1,n2) as new2 FROM table1 group by new1, new2 having count(*)> 1 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users