윈도우함수
-
[Oracle] sum() over()DB/Oracle 2019. 9. 5. 03:36
[배경] over() 내 order by 구문으로 결과가 다르게 나타난다 WITH t AS ( SELECT '20150801' dt, 1 id FROM dual UNION ALL SELECT '20150801', 2 FROM dual UNION ALL SELECT '20150801', 1 FROM dual UNION ALL SELECT '20150802', 1 FROM dual UNION ALL SELECT '20150802', 2 FROM dual UNION ALL SELECT '20150802', 2 FROM dual UNION ALL SELECT '20150803', 3 FROM dual UNION ALL SELECT '20150804', 4 FROM dual UNION ALL SELECT '201..