select dept1, count(*) from
(select e.dept as dept1,salary from employee e,
(select dept as dept2,avg(salary) as avgsal from employee group by dept) tmp
where e.dept=tmp.dept and e.salary>tmp.svgsal)
group by dept1
你是要查询什么东西哦，是在EXCEL里查询，还是用SQL查询数据库哦。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024