sql server minus clause 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

Tags:

Sql Example

Related