Oracle下复杂查询语句(二)
by job) a2 where a1.job=a2.job and a1.sal=a2.min_sal; www.2cto.com
17：列出各个部门的MANAGER的最低薪金，姓名，部门名称，部门人数
select e.sal,e.ename,d.dname, count from(select job,min(sal) sal,ename,deptno from emp where job='MANAGER'GROUP BY job,ename,deptno) e,
(select d.deptno,d.dname,count(e.empno) count fromemp e,dept d wheree.deptno=d.deptno GROUP BY d.deptno,d.dname) d
where e.deptno=d.deptno;
Oracle分页（根据ROWNUM分页）
select * from (select a1.*,rownum rn from (select ename,sal from emp order by sal) a1 where rownum<=10) where rn >=6;
作者 夜半风雨