题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
with user_log as (
select
l.log_time,
l.user_id,
u.hobby,
date(l.log_time) as log_day,
rank() over(partition by date(l.log_time) order by l.log_time) as login_rank
from login_tb l
join user_action_tb u on l.user_id=u.user_id
)
select
log_day,
user_id,
hobby
from user_log
where login_rank=1;
记录首次尝试分块实现
投递深圳虾皮信息科技有限公司等公司6个岗位
查看12道真题和解析