题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
SELECT a.date log_day,a.user_id,b.hobby
FROM (
SELECT t1.user_id,t1.date
FROM (
SELECT DATE(log_time) date,user_id,DENSE_RANK() OVER(partition by DATE(log_time)order by log_time) date_ranking
FROM login_tb
) t1
WHERE t1.date_ranking = 1
) a
LEFT JOIN user_action_tb b
ON a.user_id = b.user_id
查看17道真题和解析