tab_salary表结构:
name | varchar(50) |
departid | number |
salary | binary_float |
SQL实现:
select A.*
from tab_salary A inner join
(select max(salary) as salary,departid as departid from tab_depart
group by departid) B
on A.salary=B.salary and A.departid=B.departid
---先查出每个部门的最高工资及部门ID,然后和原始表做一个内连接。