Yurttas/PL/DBL/mysql/F/01/00/PC/q05.sql
Revision as of 16:26, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM q05.sql REM REM Find those manufacturers that sell Laptops, but not PC's. REM: \. set-db.sql (SELECT P....")
1/*
2REM
3REM q05.sql
4REM
5REM Find those manufacturers that sell Laptops, but not PC's.
6REM
7*/
8
9\. set-db.sql
10
11(SELECT P.maker
12 FROM Product P, Laptop L
13 WHERE P.model=L.model)
14MINUS
15(SELECT P.maker
16 FROM Product P, PC
17 WHERE P.model=PC.model);