A set of tables are defined as follows: t1 t2 How many rows are returned by executing the following SQL statement? SELECT * FROM t1 LEFT OUTER JOIN t2 USING (id);

The correct answer is C. 4 rows. PostgreSQL CE PGCES-02 Exam

Data Management and SQL

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 LEFT OUTER JOIN t2 USING (id);

(33 responses)

PostgreSQL CE PGCES-02 Exam

#LEFT OUTER JOIN#SQL joins#USING clause#result set size

No community discussion yet for this question.