sql查询练习题含答案.doc

文档介绍：select d.* from dept d where deptno in( select deptno from emp group by deptno having avg(sal)=( select min(avg(sal)) avgsal from emp group by deptno)) --38. 平均薪水等级最低的部门的部门名称 select from dept d where in (select from (select from emp e,salgrade s where ( between and ) group by order by avg()) a where rownum=1); --39. 部门经理人中,薪水最低的部门名称 select dname from dept where deptno= (select deptno from (select deptno from emp where job='MANAGER' group by deptno order by min(sal)) where rownum=1) --40. 比普通员工的最高薪水还要高的经理人名称 select ename from emp where sal> (select max(sal) from emp where job not in ('MANAGER','PRESIDENT')) and job='MANAGER' or job='PRESIDENT' --41. 删除重复部门,但是留下一项 insert into dept values(70,'RESEARCH','DALLAS') sel