how to subtract from the value of a table in sql
snippet in sql

how to subtract from the value of a table in sql

user4560


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