Yurttas/PL/DBL/postgres/F/01/SPJ/q10.sql
Revision as of 00:55, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM q10.sql REM REM Set the shipment quantity to zero for all suppliers in REM 'Denver'.: SELECT current_sc...")
1/*
2REM
3REM q10.sql
4REM
5REM Set the shipment quantity to zero for all suppliers in
6REM 'Denver'.
7*/
8
9SELECT current_schema();
10SET search_path to "spj";
11
12UPDATE Shipments
13SET quantity = 0
14WHERE sn IN (SELECT sn
15 FROM Suppliers
16 WHERE city = 'Denver');