メモ：メモ一覧
更新

-- あと、0の場合も作る INSERT INTO EveryDay5mData SELECT A.YMD ,A.TIME ,A.BRAND_CODE ,MAX(A.START_AMT) AS START_AMT ,MAX(B.HIGH_AMT) AS HIGH_AMT ,MIN(B.LOW_AMT) AS LOW_AMT ,MAX(C.END_AMT) AS END_AMT ,SUM(B.VOLUME) AS VOLUME ,MIN(B.START_ID) AS START_ID ,MAX(B.LAST_ID) AS LAST_ID ,'' AS TIME_NUM FROM EveryDay1mData A INNER JOIN EveryDay1mData B ON B.YMD = A.YMD AND B.BRAND_CODE = A.BRAND_CODE AND B.TIME <= CONCAT(LEFT(A.TIME,4), '4') AND B.TIME >= A.TIME INNER JOIN EveryDay1mData C ON C.YMD = A.YMD AND C.BRAND_CODE = A.BRAND_CODE AND C.TIME = CONCAT(LEFT(A.TIME,4), '4') WHERE RIGHT(A.TIME, 1) = '0' GROUP BY A.YMD ,A.TIME ,A.BRAND_CODE