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

+ Recent posts