Yurttas/PL/DBL/oracle/F/01/Company-A/q05.sql
Jump to navigation
Jump to search
1REM
2REM q05.sql
3REM
4REM Retrieve the names of employees who work on every project.
5REM
6
7SELECT DISTINCT E1.fname, E1.minit, E1.lname
8FROM Employee E1
9WHERE NOT EXISTS (SELECT pno
10 FROM WorksOn
11 WHERE pno NOT IN (SELECT pno
12 FROM Employee E2, WorksOn
13 WHERE essn = E2.ssn
14 AND E2.ssn = E1.ssn));