SELECT name,salary , dept FROM emp e WHERE NOT EXISTS (SELECT 1 FROM dept WHERE deptno = e.dept); Which employees are retrieved from the above query:
Employees who work for a department that is not listed in DEPT table.
Employees who work from department 1
Employees who work for a department with more than 1 employee
Employees who work for a department other than department 1