반응형
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 |