select t.deptno,d.dname,t.avgsal,s.grade
from (select deptno,avg(sal) as avgsal from emp group by deptno) t
join salgrade s
on t
求平均薪水的等级最低的部门的部门名称
最新推荐文章于 2022-06-12 11:55:20 发布
select t.deptno,d.dname,t.avgsal,s.grade
from (select deptno,avg(sal) as avgsal from emp group by deptno) t
join salgrade s
on t