Oracle/SQL Fundamentals I
8일차 # 4-23: Nesting Group Functions
Bohemian life
2012. 4. 13. 15:23
- nested to a depth of two.
select max(avg(salary))
from employees
group by department_id;
select department_id, max(avg(salary))
from employees
group by department_id;
