다른 분들의 코드를 참고하여 짜보았습니다! 여러분들도 참고가 됬으면 좋겠습니다:)
1 2 3 4 5 6 7 8 9 -- 코드를 입력하세요 WITH RECURSIVE TIME AS( SELECT 0 AS h UNION ALL SELECT h+1 FROM TIME WHERE h < 23) SELECT h, COUNT(HOUR(DATETIME)) AS 'COUNT' FROM TIME LEFT OUTER JOIN ANIMAL_OUTS ON (h=HOUR(DATETIME)) GROUP BY h
1 2 3 4 5 6 7 8 9
-- 코드를 입력하세요 WITH RECURSIVE TIME AS( SELECT 0 AS h UNION ALL SELECT h+1 FROM TIME WHERE h < 23) SELECT h, COUNT(HOUR(DATETIME)) AS 'COUNT' FROM TIME LEFT OUTER JOIN ANIMAL_OUTS ON (h=HOUR(DATETIME)) GROUP BY h
감사합니다
감사합니다.
굳 제일 깔끔해보여요