select minus sql code example

Example: how to subtract from the value of a table in sql

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