SQL整理

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;