SELECT   department_id, AVG(salary), max(salary)

  FROM     employees

  GROUP BY department_id;


  SELECT   department_id, AVG(salary), max(salary)

  FROM     employees

  GROUP BY department_id

  HAVING   max(salary) > 10000;


  SELECT   department_id, AVG(salary)

  FROM     employees

  GROUP BY department_id

  HAVING   max(salary) > 10000;


'Oracle > SQL Fundamentals I' 카테고리의 다른 글

8일차 # 3장, 4장 정리 문제  (0) 2012.04.13
8일차 # 4-23: Nesting Group Functions  (0) 2012.04.13
8일차 # 4-18: WHERE vs. HAVING  (0) 2012.04.13
8일차 # 4-17:  (0) 2012.04.13
8일차 # 4-14:  (0) 2012.04.13

+ Recent posts