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