select ename as '最高薪资人员的姓名' ,sal as '薪资' from emp where sal in(select max(sal) as '部门最高工资' from emp group by DEPTNO );
标签：sal,工资,部门,emp,薪资,最高,select From： https://www.cnblogs.com/haha1988/p/17773200.html
select ename as '最高薪资人员的姓名' ,sal as '薪资' from emp where sal in(select max(sal) as '部门最高工资' from emp group by DEPTNO );
标签：sal,工资,部门,emp,薪资,最高,select From： https://www.cnblogs.com/haha1988/p/17773200.html