如何求取每个部门工资前2名员工的 部门编号，姓名，工资
------解决方案--------------------
- SQL code
--晕，奖金少写了(sal+nvl(comm,0)) sal，不需要的话就只用sal吧select deptno,ename,sal from( select rank() over(partition by deptno order by (sal+nvl(comm,0)) desc) rn,deptno,ename,(sal+nvl(comm,0)) sal from emp)where rn<3;
代码迷推荐解决方案：软件开发者薪资,http://www.daimami.com/other/1391128.html