Oracle scott用户中查询 平均薪水等级最高的部门并同时列出薪水,薪水和部门名称?

SELECT dname,grade,S
FROM dept,(SELECT deptno,grade,s FROM (SELECT deptno,grade,s
FROM (SELECT deptno,avg(sal) s
FROM emp GROUP BY deptno),salgrade
WHERE s BETWEEN losal AND hisal ORDER BY grade DESC) t
WHERE ROWNUM=1) t WHERE dept.deptno=t.deptno;

select a.dname,max(a.sal) sal from
(select dept.dname,avg(emp.sal) sal from emp,dept where emp.deptno=dept.deptno
group by dept.dname) a
group by a.dname