关键字 except

select * from A
except
select * from B;

SQL：
select emp_no from employees
except
select emp_no from dept_manager;