Yurttas/PL/DBL/postgres/F/01/PC/q08.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM q08.sql
 4REM
 5REM Find the printers with the highest price.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "pc";
11
12SELECT model
13FROM Printer
14WHERE price = (SELECT MAX(price)
15               FROM Printer);