select * from
(select * from
(select * from emp where sal is not null order by sal desc )
where rownum<6)a,
(select * from
(select * from emp where hiredate is not null order by hiredate desc )
where rownum<6) b
where a.empno = b.empno
--查询工资最高的5个员工中,工龄最短的一个
select * from
(select * from
(select * from
(select * from emp where sal is not null order by sal desc )
where rownum<6)
where hiredate is not null
order by hiredate desc
) where rownum<2