Question

oracle中scott的的分页查询的简单问题，查找每个部门最高工资的人的详细信息

select * from emp t1, (select max(sal) t2maxsal from emp group by deptno) t2 where t1.deptno=t2.deptno and t1.sal=t2maxsal;
select emp.ename from emp t1, (select max(sal) t2maxsal from emp group by deptno) t2 where t1.deptno=t2.deptno and t1.sal=t2.t2maxsal;

是这个才对

Answer 1

select t.1* from
emp t1,
(deptno,select max(sal) t2maxsal from emp group by deptno) t2
where t1.deptno=t2.deptno
    and t1.sal=t2.t2maxsal;