题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
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