4回答

• 

  吴学究

  2015-12-18 10:43:24

  已采纳

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

  3 1

  修德

  确实是错的！！！

  2016-12-09 16:49:56

  共 3 条回复 >

• 

  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);

  
  

  0 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 1

  洪小仔

  嗯嗯 多谢

  2016-12-01 16:47:25

  共 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;
  

  0 1