Yurttas/PL/DBL/mysql/F/01/00/PC/q08.sql

From ZCubes Wiki
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 q08.sql REM REM Find the printers with the highest price. REM: \. set-db.sql SELECT model FROM Printer ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 1/*
 2REM
 3REM q08.sql
 4REM
 5REM Find the printers with the highest price.
 6REM
 7*/
 8
 9\. set-db.sql
10
11SELECT model
12FROM Printer
13WHERE price = (SELECT MAX(price)
14               FROM Printer);