开心就好~~~专栏

--求部门中哪些人的薪水最高 select * from emp join (select max(sal) max_sal,deptno from emp group by deptno) t on(emp.sal = t.max_sal and emp.deptno = t.deptno); --求每个部门的平均薪水  然后求出平均薪水的等级 select * from(selec

--求出每个部门工资总和  每个岗位工资总和  每个雇员总工资 select '各部门工资总和',e.deptno||' ',sum(e.sal) from emp e group by e.deptno union all select '各岗位工资总和',e.job||' ',sum(e.sal) from emp e group by e.job union all select