查询练习（二）

显示SALES部门的位置和员工姓名
select d.loc,e.ename,d.deptno from emp as e,dept as d where d.dname='sales' and d.deptno=e.deptno

显示员工姓名，工资，所在部门名
select e.ename,e.sal,d.dname,d.deptno from emp as e,
dept as d where e.deptno=d.deptno

显示部门号为10的部门名及员工工资和名字
select e.ename,e.sal,d.dname,d.deptno from emp as e,
dept as d where e.deptno=d.deptno and d.deptno=10

显示部门名，工资，员工名，并排序
select e.ename,e.sal,d.dname,d.deptno from emp as e ,
dept as d where e.deptno=d.deptno order by d.dname
自连接：在同一张表上的连接
显示员工上司，ADAMC
select ename from emp where empno=(select  mgr from emp where ename='adamc')

显示每个员工和上司名字
select boss.ename,worker.ename from emp as boss,emp as
worker where worker.mgr=boss.ename

显示与JONES同一部门的所有员工。
select * from emp where deptno=(select deptno from emp where ename='jones')

查询部门号为10的员工名，岗位，工资，部门号，（不可用=）
select ename,job,sal,deptno from emp where deptno in(10)
select ename,job,sal,deptno from emp where
job in(select job from emp where deptno=10)