Query operators allow queries to be combined using set operators.
In this Topic:
[(] query [)] operator [(] query [)] [ORDER BY ...] [LIMIT ...]
- Each query may itself contain query operators, to allow any number of query expressions to be combined with set operators.
- The ORDER BY and LIMIT clauses are applied to the result of the set operator.
Returns rows from one query’s result set which also appear in another query’s result set, with duplicate elimination.
SELECT ... FROM ... INTERSECT SELECT ... FROM
MINUS / EXCEPT¶
Removes rows from one query’s result set which appear in another query’s result set, with duplicate elimination. The MINUS and EXCEPT keywords have the same meaning.
SELECT ... FROM ... MINUS SELECT ... FROM SELECT ... FROM ... EXCEPT SELECT ... FROM