This topic describes the MINUS clause.
The following statement provides the general syntax of the MINUS clause:
select_statement MINUS select_statement
select_statement is a
SELECT statement that does not contain an
ORDER BY or
MINUS operator computes the set of rows that are in the result of the left
SELECT statement but not in the result of the right one.
The result of the
MINUS clause does not contain duplicate rows.
Unless otherwise specified in parentheses, multiple
MINUS operators in the same
SELECT statement are evaluated from left to right. The
MINUS clause binds at the same level as the