오라클 GROUP BY

[형식]

SELECT 컬럼명, 그룹함수

FROM 테이블명

WHERE 조건(연산자)

GROUP BY 컬럼명;

EX) SELECT DEPTNO FROM EMPGROUP BY DEPTNO; //부서별 번호가 나옴.. 

EX)SELECT AVG(SAL) FROM EMP GROUP BY DEPTNO;//부서별 월급 평균

EX)SELECT DEPTNO,AVG(SAL) FROM EMP GROUP BY DEPTNO;//부서별 번호와 부서별 평균 급여