子查询

select语句嵌套select语句被称为子查询

where

select avg(sal) as avgsal from emp;

找出薪水比公司平均薪水高的员公，显示员工名和薪水

 select ename,sal from emp where sal >  (select avg(sal) as avgsal from emp);

from
（可以用在临时表来起作用）

找出每个部门的平均薪水，并且要求显示平薪水的薪水等级

select e.deptno,avg(e.sal) as avgsal  from emp group by e.deptno ;(把这个表当成临时表t)

select t.avgsal , s.grade from t join salgrade s on t.avgsal between s.losal ang s.hisal;

把所有的t替换成select e.deptno,avg(e.sal) as avgsal  from emp group by e.deptno