题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
select
log_day
,user_id
,hobby
from
(
select
rank() over(partition by date_format(log_time,'%Y-%m-%d') order by log_time asc) as rk
,date_format(log_time,'%Y-%m-%d') as log_day
,u.user_id
,u.hobby
from login_tb l
left join user_action_tb u
on l.user_id = u.user_id
) t1
where rk =1 ;
查看14道真题和解析
