본문 바로가기
Oracle(DB관련)

그룹별 합계, 누적합계 sum()

by xfree302 2009. 11. 4.
반응형

SELECT code01, code02, name, point,
       sum(point) over(partition by code01),
       sum(point) over(partition by code01 order by code01, code02, point),
       sum(point) over(order by code01, code02, point),
       sum(point) over()
FROM tb_aaa;
반응형

'Oracle(DB관련)' 카테고리의 다른 글

문자함수  (0) 2009.11.04
날짜함수  (0) 2009.11.04
순서정하기 rank()  (0) 2009.11.04
sys_connect_by_path row데이터를 column데이터로  (0) 2009.11.04
merge into 있으면 update, 없으면 insert  (0) 2009.11.03