求部门中最高工资的人是谁

select ename as '最高薪资人员的姓名' ,sal as '薪资' from emp where sal in(select  max(sal) as '部门最高工资' from emp  group by DEPTNO  );