Yurttas/PL/DBL/oracle/F/01/Company-B/q07.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM q07.sql
 3REM
 4REM Find all employees who earn more than every employee of
 5REM 'Small Bank Corporation'.
 6REM
 7
 8SELECT employeename 
 9FROM Works 
10WHERE salary > ALL (SELECT salary 
11                    FROM Works 
12                    WHERE companyname='Small Bank Corporation');