每部门平均薪水的等级
select * from salgrade s1
join (select avg(sal) avg_sal from emp group by deptno) t
on (t.avg_sal between s1.losal and s1.hisal)
---------------
每部门薪水最高的人
select sal,ename from emp
join (select max(sal) max_sal from emp group by deptno)t
on (t.max_sal = emp.sal)
部门薪水的平均等级
select avg(grade),deptno
from
(select sal,e2.grade,e1.deptno,ename
from emp e1
join salgrade e2
on (e1.sal between e2.losal and e2.hisal)) t
group by deptno
-----------
哪些人是经理人 (下边管着人
select * from emp where empno in (select distinct mgr from emp)
不用MAX函数 求薪水最大
select sal from emp where sal not in(select distinct e1.sal from emp e1
join emp e2
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载