항목의 누적 data를 출력하는 query
1항목 2항목 3항목이 있을 때 각 항목의 data는 각각의 data를 출력하는 것이 아니라 1항목은 1항목 data, 2항목은 1항목+2항목, 3항목은 1항목+2항목+3항목 이렇게 누적 data를 출력하는 query예제. WITH WITH_T AS ( SELECT 1 AS MM, 2 AS V FROM DUAL UNION ALL SELECT 2 AS MM, 4 AS V FROM DUAL UNION ALL SELECT 3 AS MM, 6 AS V FROM DUAL UNION ALL SELECT 4 AS MM, 8 AS V FROM DUAL UNION ALL SELECT 5 AS MM, 10 AS V FROM DUAL UNION ALL SELECT 6 AS MM, 12 AS V FROM DUAL UNION ..
Programming/Database
2007. 11. 16. 16:12