WITH t AS ( SELECT 1 id, '2022-01-24' dt, '새우깡' nm, 10 cnt UNION ALL SELECT 2, '2022-01-24', '새우깡', 20 UNION ALL SELECT 3, '2022-01-24', '새우깡', 30 UNION ALL SELECT 4, '2022-01-24', '새우꽁', 20 UNION ALL SELECT 5, '2022-01-24', '새우꽁', 30 UNION ALL SELECT 6, '2022-01-25', '새우꽁', 20 UNION ALL SELECT 7, '2022-01-25', '새우꽁', 30 ) SELECT id , dt , nm , cnt , SUM(cnt) OVER(ORDER BY id) tot -- 누계 , SUM(cnt) OVER(PARTITION BY nm ORDER BY id) tot1 -- 품목별 누계 , SUM(cnt) OVER(PARTITION BY dt, nm ORDER BY id) tot2 -- 일별/품목별 누계 FROM t ;