๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

SQL1

[MySQL] ์‹œ๊ฐ„๋Œ€๋ณ„ ๋ฐฉ๋ฌธ ํ†ต๊ณ„ ๊ตฌํ•˜๊ธฐ ๋ฐฉ๋ฒ• 1 SELECT Hour(access_date) AS hh , count(access_date) AS cnt FROM access_log WHERE access_date BETWEEN '2022-01-01 00:00:00' AND date_format(now(),'%Y-%m-%d 23:59:59') GROUP BY hh ORDER BY hh ASC; access_date ์—์„œ Hour() ๋กœ ์‹œ๊ฐ„๊ฐ’(0,1,2,3...) ๋งŒ ๊ฐ€์ ธ์˜จ ๋’ค ๊ทธ ๊ฐ’์„ GROUP BY ๋ฅผ ํ†ตํ•ด ์ค‘๋ณต ์ œ๊ฑฐ์™€ ํ•จ๊ป˜ count ๊ฐ’์„ ๊ตฌํ•œ๋‹ค BETWEEN AND ์ ˆ๋กœ ๊ตฌํ•˜๊ณ ์ž ํ•˜๋Š” ๊ธฐ๊ฐ„์„ ์ง€์ •ํ•œ๋‹ค ์ถœ๋ ฅ ์œ„์™€ ๊ฐ™์€ ๋ฐฉ๋ฒ•์€ ๊ฐ’์ด ์žˆ๋Š” ์‹œ๊ฐ„๋งŒ ์ถœ๋ ฅ์„ ํ•œ๋‹ค. ๊ฐ’์˜ ์œ ๋ฌด์™€ ์ƒ๊ด€์—†์ด 1~24 ์‹œ๊ฐ„๋Œ€๋ณ„ ๋ฐฉ๋ฌธ ํ†ต๊ณ„๊ฐ€ ํ•„์š”ํ•˜๋‹ค. ๋ฐฉ๋ฒ• 2 ์šฐ์„  ํ–‰๋ฒˆ.. 2022. 10. 19.
๋ฐ˜์‘ํ˜•

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”