Introduction to Oracle MINUS Operator
The Oracle MINUS operator compares two queries and returns distinct rows from the first query that are not output by the second query. In other words, the MINUS operator subtracts one result set from another.
See the following contacts and employees tables in the sample database:
The following statement returns distinct last names from the query to the left of the MINUS operator which is not also found in the right query.
SELECT last_name FROM contacts MINUS SELECT last_name FROM employees ORDER BY last_name;
Posted from:https://www.oracletutorial.com/oracle-basics/oracle-minus/
Examine the description of the SALES1 table:
SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?
- A. INTERSECT
- B. UNION ALL
- C. UNION
- D. SUBTRACT
- E. MINUS