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