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