- 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;
'Oracle > SQL Fundamentals I' 카테고리의 다른 글
8일차 Join (0) | 2012.04.13 |
---|---|
8일차 # 3장, 4장 정리 문제 (0) | 2012.04.13 |
8일차 # 4-21: HAVING clause (0) | 2012.04.13 |
8일차 # 4-18: WHERE vs. HAVING (0) | 2012.04.13 |
8일차 # 4-17: (0) | 2012.04.13 |