오늘 시간대별
데이터 가져오는 쿼리 입니다.
어떻게 수정해야할까요ㅠㅠ
감이 안와서요 좀 도와주세요
SELECT ROUND(IF( POWER < 0, 0, POWER) / 1000, 3) AS POWER, HOUR FROM (SELECT CAST(MAX(T1.WIND_PCS_TODAY_DEVL)- (SELECT MAX(S1.WIND_PCS_TODAY_DEVL) FROM MEASURE_WIND_PCS S1 WHERE DATE_FORMAT(S1.WIND_PCS_REG_DATE, '%Y-%m-%d %H') = DATE_FORMAT(DATE_ADD(T1.WIND_PCS_REG_DATE,interval -1 hour), '%Y-%m-%d %H') GROUP BY DATE_FORMAT(S1.WIND_PCS_REG_DATE, '%Y-%m-%d %H') ) AS SIGNED) AS POWER, DATE_FORMAT(T1.WIND_PCS_REG_DATE, '%H') AS HOUR FROM MEASURE_WIND_PCS T1 WHERE T1.WIND_PCS_REG_DATE >= CURDATE() AND DATE_FORMAT(T1.WIND_PCS_REG_DATE, '%H') <> '00' GROUP BY DATE_FORMAT(T1.WIND_PCS_REG_DATE, '%Y-%m-%d %H') ) TA
SELECT hour , power FROM (SELECT hour , ROUND(GREATEST(v - @v, 0) / 1000, 3) power , @v := v FROM (SELECT DATE_FORMAT(t1.wind_pcs_reg_date, '%H') hour , MAX(t1.wind_pcs_today_devl) v FROM measure_wind_pcs t1 WHERE t1.wind_pcs_reg_date >= CURDATE() AND t1.wind_pcs_reg_date < CURDATE() + INTERVAL 1 DAY GROUP BY DATE_FORMAT(t1.wind_pcs_reg_date, '%H') ORDER BY hour ) a , (SELECT @v := '') b ) c WHERE hour <> '00' ;