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

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM q060.sql
 3REM
 4REM Find all employees who do not work for 'First Bank Corporation'.
 5REM
 6REM [ Assume that all people work for exactly one company. ]
 7REM
 8
 9SELECT employeename 
10FROM Works 
11WHERE companyname <> 'First Bank Corporation';