6.2

The Subquery in an UPDATE statement

The Subquery in an UPDATE statement

Code Sample:

1    UPDATE country 
2    SET GNPOld = 0.00 
3    WHERE Code IN 
4    (SELECT CountryCode FROM countrylanguage WHERE population = 0)

Results:

sub_02.png

UPDATE country

SET GNPOld = 0.00

WHERE Code IN

(SELECT CountryCode FROM countrylanguage WHERE population = 0)

CC BY-NC-ND International 4.0

CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.