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 |