题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
SELECT
t.log_day,
t.user_id,
t.hobby
FROM (
SELECT
DATE(log_time) AS log_day,
l.user_id,
hobby,
RANK() OVER(PARTITION BY DATE(log_time) ORDER BY HOUR(log_time)+MINUTE(log_time)/60+SECOND(log_time)/3600) AS rk
FROM login_tb l JOIN user_action_tb u
ON l.user_id = u.user_id ) t
WHERE rk < 2
ORDER BY log_day
