A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 WHERE EXISTS (SELECT name FROM t2 WHERE t1.id = t2.id);

The correct answer is B. 2 rows. See the full explanation below for the reasoning.

Question

A set of tables are defined as follows:

t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 WHERE EXISTS (SELECT name FROM t2 WHERE t1.id = t2.id);

(44 responses)

No community discussion yet for this question.