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