Nancy Greenberg 12000.00 100
Shelley Higgins 12000.00 110
11 rows selected
/*--------10、最高的部门平均工资是多少。---------*/ SQL> SELECT MAX(AVGSALARY)
2 FROM(SELECT DEPARTMENT_ID,AVG(SALARY) AVGSALARY 3 FROM EMPLOYEES
4 GROUP BY DEPARTMENT_ID);
MAX(AVGSALARY) -------------- 21333.33333333
