个回答

• 吴学究

  2015-12-18 10:43:24

  已采纳

   select deptno,max(avg(sal)) from emp group by deptno

  1

• creolive

  2018-02-19 17:16:22

  select deptno,avg(sal) 

  from emp group by deptno

  having avg(sal) =

  (select max(avg(sal)) from emp group by deptno);

  
  

  2

• 红袖侍读

  2016-10-31 02:28:50

  上面的sql语句漏了desc

  select *

  from (select deptno, avg(sal) avgsal

            from emp

            group by deptno

            order by avgsal desc)

  where rownum=1;
  

  1

• 红袖侍读

  2016-10-31 02:27:22

  一楼那个写法是错的，max似乎不能跟部门号同时使用，我想了个比较绕的办法把最大部门平均工资跟部门号一起显示出来，欢迎有同学贡献更好的办法

  select *
  

  from (select deptno, avg(sal) avgsal
  

            from emp

            group by deptno

            order by avgsal)

  where rownum=1;
  

  1