Divya Sharma
0
Q:

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.
1

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

New to Communities?

Join the community