select empno,ename,sal,emp.deptid
from emp 
left join (select deptid,max(sal) as 最高工资 from emp group by deptid) as t
on emp.deptid=t.deptid
where sal=最高工资;