Yurttas/PL/DBL/oracle/F/01/PC/q12.sql

From ZCubes Wiki
Revision as of 23:03, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM q12.sql REM REM Delete all PC's with less than 2 gigabyte of hard disk. REM DELETE FROM Product WHERE model ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search 
 1REM
 2REM q12.sql
 3REM
 4REM Delete all PC's with less than 2 gigabyte of hard disk.
 5REM
 6
 7DELETE FROM Product
 8WHERE model IN (SELECT model
 9		FROM PC
10                WHERE hd<2.0);
11
12DELETE FROM PC
13WHERE hd<2.0;
Retrieved from "http://wiki.zcubes.com/index.php?title=Yurttas/PL/DBL/oracle/F/01/PC/q12.sql&oldid=79453"