SQLize | PHPize | SQLtest

-- create table t1(a int); -- create table t2(a int); -- insert into t1 values(1); -- insert into t1 values(3); -- insert into t1 values(5); -- insert into t1 values(7); -- insert into t2 values(2); -- insert into t2 values(4); -- insert into t2 values(6); -- insert into t2 values(8); -- insert into t2 values(1); -- insert into t2 values(7); -- select * from t1 where a not in (select a from t2); -- select * from t1 where a in (select a from t2); -- select t1.a from t1 left join t2 on t1.a = t2.a; create table a(val int); create table b(val int); create table c(val int); insert into a values(1); insert into a values(3); insert into a values(5); insert into a values(8); insert into a values(2); insert into b values(1); insert into b values(3); insert into b values(7); insert into b values(9); insert into c values(1); insert into c values(3); insert into c values(5); insert into c values(8); insert into c values(2); explain plan for --explain select a.val from a where exists ( select b.val from b where b.val <> a.val and b.val * a.val < 120 * b.val and b.val > 10 or b.val < 20 ); select * from table(dbms_xplan.display);