關(guān)與分組函數(shù)嵌套問題
select select max(avg(sal)) from emp group by deptno中怎么樣可以同時把deptno 號顯示出來呢？
4 回答
舉報(bào)
0/150
提交
取消
select select max(avg(sal)) from emp group by deptno中怎么樣可以同時把deptno 號顯示出來呢？
2015-09-22
舉報(bào)
2015-12-18
?select deptno,max(avg(sal)) from emp group by deptno
2018-02-19
select deptno,avg(sal)?
from emp group by deptno
having avg(sal) =
(select max(avg(sal)) from emp group by deptno);
2016-10-31
上面的sql語句漏了desc
select *
from (select deptno, avg(sal) avgsal
????????? from emp
????????? group by deptno
????????? order by avgsal desc)
where rownum=1;
2016-10-31
一樓那個寫法是錯的，max似乎不能跟部門號同時使用，我想了個比較繞的辦法把最大部門平均工資跟部門號一起顯示出來，歡迎有同學(xué)貢獻(xiàn)更好的辦法
select *
from (select deptno, avg(sal) avgsal
????????? from emp
????????? group by deptno
????????? order by avgsal)
where rownum=1;