Select petname from pet1 minus select petname from

“SELECT PET_NAME FROM PET1 MINUS SELECT
PET_NAME FROM PET2;” must have the same
results as “SELECT PET_NAME FROM PET2
MINUS SELECT PET_NAME FROM PET1;”.
This is false.
A particular DBMS may not support the MINUS
statement.
This is true. The INTERSECT statement
may not be supported by a particular
DBMS either.
You want the results of the query “SELECT
pet_name FROM Pet1 MINUS SELECT pet_name
FROM Pet2;”, but the DBMS that you are using does
not support the MINUS statement. You could get the
results that you want with this query: “SELECT
pet_name FROM Pet1 WHERE pet_name NOT IN
(SELECT pet_name FROM Pet2);”.
This is true. This is another way to obtain
these results.
Page 46 of 46 Module 3
5/14/2015 ...