题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
with l as(
select user_id,date(log_time) as log_day,rank()over(partition by date(log_time) order by log_time) as rn
from login_tb
)
select log_day,l.user_id,hobby
from l join user_action_tb u on l.user_id=u.user_id
where rn=1 order by log_day
查看10道真题和解析