sql select minus select code example
Example: how to subtract from the value of a table in sql
UPDATE Inventory
SET Quantity = Quantity - 1
WHERE InventoryID = 2
UPDATE Inventory
SET Quantity = Quantity - 1
WHERE InventoryID = 2