Update command syntax in Snowflake
Updates specified rows in the target table with new values.
SET quantity = quantity - 10
WHERE product like '%washer%';
To update a table from another table:
UPDATE Inventory i
SET i.quantity = n.quantity
select quantity,product from NewArrivals
WHERE i.product = n.product;
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds