列出各个部门中工资高于本部门的平均工资的员工数和部门号,并按部门号排序.用SQL语句详细介绍一下,谢

Question

列出各个部门中工资高于本部门的平均工资的员工数和部门号,并按部门号排序.用SQL语句详细介绍一下,谢

Answer 1

select a.deptno,count(*) from emp as a,(select deptno,avg(sal) as avgsal from emp group by deptno) as bwhere a.deptno=b.deptnoand a.sal>b.avgsalgroup by a.deptnoorder by a.deptno 表名为emp,deptno为部...