MINUS Operator

All the distinct rows selected through the first query but that are not in the second query are listed.

 
Example

SELECT * FROM x
MINUS
SELECT * FROM y
Records available in table X which are not available in table Y are displayed. The output will look like:

ITEMCODE    NAME

1                 Powders
4                    Pens

All set operators have equal precedence. An ORACLE evaluates them from left to right if a SQL statement contains multiple sets of operators. Parentheses have to be used to explicitly specify another order If the order is to be changed. These querying tables can hold variant structures. But the type of the data in the tables must match.