Horje Website
SQL Using Subquery In Update Statement – MYsql Code

SQL Using Subquery In Update Statement

SQL Using Subquery In Update Statement - SQL Code


 
  1. UPDATE orders
  2. SET order_value = order_value + 10
  3. WHERE cust_id IN (SELECT cust_id FROM customers WHERE postal_code = 75016);



Try Your Self ->



Published:
 September 28, 2020
Author:
 admin
Category:
 SQL Advanced, SQL Source Code
Views:
 21

This article was posted in SQL Advanced, SQL Source Code and tagged , , . Bookmark the permalink. Follow comments with the RSS feed for this post.Post a Comment or leave a trackback: Trackback URL.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Horje © 2011 - 2023