1.查询每个部门的最高工资:
select deptno, max(sal) min_sal from emp group by deptno;
2.同最低工资关联人员信息:
select e.* from emp e, (select deptno, min(sal) min_sal from emp group by deptno) s where e.deptno = s.deptno and e.sal = s.min_sal;
SQL整理
最新推荐文章于 2024-09-26 18:25:47 发布