PostgreSQL_CE
PGCES-02 · Question #21
The tables "t1" and "t2" are defined in the same way (they have the same data types and column names). You want to select rows in "t1" which are not in "t2". Select a correct keyword to fill in the…
The correct answer is A. EXCEPT. See the full explanation below for the reasoning.
Question
The tables "t1" and "t2" are defined in the same way (they have the same data types and column names). You want to select rows in "t1" which are not in "t2". Select a correct keyword to fill in the blank below. SELECT * FROM t1 ______ SELECT * FROM t2;
Options
- AEXCEPT
- BUNION
- CNAND
- DINTERSECT
- EINTERSECT ALL
How the community answered
(21 responses)- A76% (16)
- C5% (1)
- D5% (1)
- E14% (3)
Community Discussion
No community discussion yet for this question.