*FROM, WHERE, GROUP BY, HAVING 절 이후 OVER절 계산
집계함수
SELECT
ID
, SALARY
, (SELECT AVG(SALARY)
FROM EMPLOYEES
) AS AVG_SALARY,
, (SELECT SUM(SALARY)
FROM EMPLOYEES
) AS SUM_SALARY
FROM EMPLOYEES위와 같은 서브쿼리를 아래 OVER 절로 치환
SELECT
ID
, SALARY
, AVG(SALARY) OVER() AVG_SALARY
, SUM(SALARY) OVER() SUM_SALARY
FROM EMPLOYEES분석함수
OVER(PARTIRION BY Column / ORDER BY Column / 세부분할기준)
PARTIRION BY
→ OVER절 안에 GROUP BY 사용
ORDER BY Column
→ OVER절 안에 정렬 사용
세부분할기준
→ 추가적 분할 조건 사용