minus in sql code example
Example 1: minus in sql
The SQL MINUS operator is used to return
all rows in the first SELECT statement
that are not returned by the second SELECT statement.
Each SELECT statement will define a dataset.
]The MINUS operator will retrieve all records
from the first dataset and then remove from
the results all records from the second dataset.
Example 2: how to subtract from the value of a table in sql
UPDATE Inventory
SET Quantity = Quantity - 1
WHERE InventoryID = 2