select ename as '最高薪资人员的姓名' ,sal as '薪资' from emp where sal in(select max(sal) as '部门最高工资' from emp group by DEPTNO );
求部门中最高工资的人是谁
发布时间 2023-10-18 19:52:20作者: 无知者无畏123
select ename as '最高薪资人员的姓名' ,sal as '薪资' from emp where sal in(select max(sal) as '部门最高工资' from emp group by DEPTNO );