SELECT DEPARTMENT_ID,
JOB_ID,
COUNT(SALARY),
SUM(SALARY)
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID, JOB_ID,
OVER PARTITION BY 를 쓰면 GROUP BY 를 안써도 됨
SELECT DEPARTMENT_ID,
JOB_ID,
COUNT(SALARY) OVER ( PARTITION BY SALARY )
SUM(SALARY) OVER ( PARTITION BY SALARY)
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID, JOB_ID,
'Oracle' 카테고리의 다른 글
| 실행계획 (0) | 2017.03.06 |
|---|---|
| START WITH CONNECT BY (0) | 2017.02.23 |
| EXISTS (0) | 2017.02.21 |
| EXPLAIN PLAN FOR (0) | 2017.02.20 |
| rowid (0) | 2017.02.14 |