- 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

+ Recent posts