# 根据部门编号归类 结果出3个部门 select DEPTNO from emp group by DEPTNO; # 找经理的名字和工资 select ENAME ,sal from emp where JOB='MANAGER'; # 列出各个部门里领导最低的薪资 3个部门里找到经理的最低工资 select DEPTNO ,min(sal) from emp where JOB='MANAGER' group by DEPTNO;
标签：各个部门,group,sal,薪水,最低,emp,DEPTNO,select From： https://www.cnblogs.com/haha1988/p/17768331.html