[ORACLE] 특정 날짜를 기준으로 그룹생성
WITH test AS ( SELECT '1' grp , '1' seq , '20070111' dt , 500 amt FROM dual UNION ALL SELECT '1' , '2' , '20070128' , 1000 FROM dual UNION ALL SELECT '1' , '3' , '20070215' , 800 FROM dual UNION ALL SELECT '1' , '4' , '20070222' , 300 FROM dual UNION ALL SELECT '1' , '5' , '20070301' , 400 FROM dual UNION ALL SELECT '1' , '6' , '20070305' , 600 FROM dual UNION ALL SELECT '1' , '7' , '20070310' ,..
더보기