MINUSExample The following statement combines results with the
MINUSoperator, which returns only unique rows returned by the first query but not by the second:
SELECT product_id FROM inventories MINUS SELECT product_id FROM order_items;
I'm just curious what's the historic reason for using
MINUS instead of
EXCEPT? Does anyone else use
MINUS? I assume this predates the SQL Spec?