题解 | #广告点击的高峰期#
广告点击的高峰期
https://www.nowcoder.com/practice/6756d65784f9413b8505c1d0c6754b3a
一种不严谨的写法,如果有多个最大点击数时,结果只有一行。
SELECT HOUR(click_time ) click_hour, COUNT(HOUR(click_time )) click_cnt FROM user_ad_click_time GROUP BY HOUR(click_time ) ORDER BY click_cnt DESC LIMIT 1