题解 | #广告点击的高峰期#
广告点击的高峰期
https://www.nowcoder.com/practice/6756d65784f9413b8505c1d0c6754b3a
SELECT t1.click_hour, MAX(t1.click_cnt) click_cnt FROM (SELECT HOUR(click_time) click_hour, COUNT(trace_id) click_cnt FROM user_ad_click_time GROUP BY click_hour) t1 GROUP BY t1.click_hour LIMIT 1
这里获取全组最大值并返回对应id，可以用MAX + GROUP BY + LIMIT 1的简单组合
投递三一重工等公司10个岗位