查询岗位是经理或销售员的人的信息 select * from emp where JOB = 'MANAGER' or job='SALESMAN'; 或者 where JOB in('MANAGER','SALESMAN');