Yurttas/PL/DBL/mssql/F/01/PC/q08.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 q08.sql REM REM Find the printers with the highest price. REM: SELECT model FROM Printer WHERE price = (...")
(diff) ← Older revision | Latest revision (diff) | Newer revision β†’ (diff)
 1/*
 2REM
 3REM q08.sql
 4REM
 5REM Find the printers with the highest price.
 6REM
 7*/
 8
 9SELECT model
10FROM Printer
11WHERE price = (SELECT MAX(price)
12               FROM Printer);