A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT FROM t1 UNION ALL SELECT FROM t2;

The correct answer is D. 5 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 UNION ALL SELECT * FROM t2;

(57 responses)

No community discussion yet for this question.