코딩연습이 좋아서/SQL이 좋아서
입양 시각 구하기(2)
zoaseo
2025. 2. 6. 22:44
SET @HOUR = -1;
SELECT(@HOUR := @HOUR + 1) AS HOUR,
(SELECT COUNT(*)
FROM ANIMAL_OUTS
WHERE HOUR(DATETIME)=@HOUR) AS COUNT
FROM ANIMAL_OUTS
WHERE @HOUR < 23;