查询每个部门工资前几名

 

select deptno, ename, sal   ,empno   
from emp e1     
where      
   (  
    select count(*)     
    from emp e2     
    where e1.deptno=e2.deptno and e1.sal <=e2.sal 
   ) <=3   -- 这里表示查询的前几名
order by deptno, sal desc;