[Oracle] 누적접수건수
·
Database
SELECT TO_CHAR (REG_DATE, 'YYYY-MM-DD') AS "접수일", COUNT (1) "접수건수", SUM (COUNT (1)) OVER (ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')) "누적접수건수" FROM N_BOARD_EVENT GROUP BY TO_CHAR (REG_DATE, 'YYYY-MM-DD') ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')