minus in sql
snippet in sql

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.

how to subtract from the value of a table in sql


UPDATE Inventory
   SET Quantity = Quantity - 1
 WHERE InventoryID = 2