PARTITION BY 집계함수(컬럼명) OVER(PARTITION BY 부분집계 기준 컬럼) - 부분 집계된 컬럼 추가 - 행 갯수 변경 없이 추가 예시) SELECT AGE , AVG(AGE) OVER(PARTITION BY SUBSTRING(AGE, 1, 1)) FROM STUDENT ORDER BY AGE 예시) SELECT SUBSTRING(AGE, 1, 1) , AVG(AGE) FROM STUDENT GROUP BY SUBSTRING(AGE, 1, 1)
