185. Department Top Three Salaries

问题描述

解决方案

 select b.name Department,a.name Employee,a.salary Salary 
 from Employee a,Department b 
 where a.departmentid=b.id and  
        (select count(distinct salary) 
            from Employee 
            where departmentid=a.departmentid and salary>a.salary
        )<3 
 order by departmentid asc,salary desc   ;

参考资料

• sql取出每个分组的前几条 http://blog.csdn.net/zhichao2001/article/details/6068893