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);
YesNo
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.