查询各个部门员工工资最高的三个员工(包括并列)
select ename, job, deptno, sal
from (select ename,
job,
deptno,
sal,
rank() over(partition by deptno order by sal) rowno
from emp)
where rowno between 1 and 3;