题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
with a as (
select
user_id,
log_time,
dense_rank()over(partition by left(log_time,10) order by log_time asc) as rk
from login_tb t1
)
select
date(log_time) as log_day,
t2.user_id,
t2.hobby
from user_action_tb t2
left join a
on a.user_id=t2.user_id
where rk =1
order by 1 asc
美的集团公司福利 819人发布