题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
select log_day,
user_id,
hobby
from (
select date(log_time) log_day,
l.user_id,
hobby,
dense_rank() over (partition by date(log_time) order by log_time) rk
from login_tb l
join user_action_tb u using (user_id)
) t
where rk=1
order by log_day
