Yurttas/PL/DBL/mssql/F/01/PC/q02.sql

Revision as of 04:35, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">β†’β€ŽREM REM q02.sql REM REM Which manufactures make laptops with a hard disk of REM at least one gigabyte? REM: SELE...")
(diff) ← Older revision | Latest revision (diff) | Newer revision β†’ (diff)
 1/*
 2REM
 3REM q02.sql
 4REM
 5REM Which manufactures make laptops with a hard disk of
 6REM at least one gigabyte?
 7REM
 8*/
 9
10SELECT DISTINCT P.maker
11FROM Product P, Laptop L
12WHERE P.model=L.model
13  AND L.hd>=1.0;