嵌套分組函數(shù)的問題
select max(avg(sal)) from emp group by deptno;
這句是正確的
select deptno,max(avg(sal)) from emp group by deptno;
這句是錯的。
car
2016-10-24
1 回答
舉報
0/150
提交
取消
2016-10-26
select?max(avg_sal) from?
(select deptno,avg(sal) avg_sal from emp group by deptno);