Oracle+SQL:经典查询练手四篇

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