mysql
select
d.name Department,
e.name Employee,
salary Salary
from
Employee e
join Department d on e.departmentId = d.id
where
salary in (
select
salary
from
(
select
distinct salary
from
employee e2
where
e.departmentId = e2.departmentId
order by
salary desc
limit
3
) a
)
limit是mysql特有
rownum是orcle特有
此题注意一个点 salary排三 而不是所有的按工资排 取三