【13巩固练习单表子查询和学习多条件查询方法】

巩固练习单表子查询和学习多条件查询方法

//查询经理名字为CLARK的属下员工
select * from emp where mgr =
(select empno from emp where ename = ‘CLARK’)

//查询哪些员工被老板(president)直接管理
select * from emp where mgr =
(select empno from emp where job = ‘PRESIDENT’)

//多条件查询
//查询工资高于1000并且岗位为CLERK的员工信息
select * from emp where sal >1000 and job =‘CLERK’

//查询岗位为CLEAR 或者 岗位为MANAGER的员工信息
select * from emp where job = ‘CLERK’ or job = ‘MANAGER’