This tests whether the specified subquery contains result rows.
CREATE TABLE t (i DECIMAL);INSERT INTO t VALUES 1,2;CREATE TABLE t2 (j DECIMAL);INSERT INTO t2 VALUES 2;SELECT i FROM t WHERE EXISTS (SELECT * FROM t2);SELECT i FROM t WHERE EXISTS (SELECT * FROM t2 WHERE t.i=t2.j);
Please let us know how we can improve.
If there's anything we can improve on, let us know.
To help us understand your feedback, please check the box in the feedback form to automatically include the URL to this page.