exists的用法为，验证是否存在满足子查询的条件 select * from employees where not exists (select dept_no from dept_emp where employees.emp_no=dept_emp.emp_no )