题解 | 每天登陆最早的用户的内容喜好
每天登陆最早的用户的内容喜好
https://www.nowcoder.com/practice/24bb13a28267486ba86c1d21459fa90a
SELECT
log_day,
user_id,
hobby
FROM(
SELECT
l.user_id,
DATE(log_time) AS log_day,
DENSE_RANK() OVER(PARTITION BY DATE(log_time) ORDER BY log_time) AS time_rank,
log_time,
hobby
FROM login_tb l
JOIN user_action_tb u
ON l.user_id = u.user_id
) AS tb1
WHERE time_rank = 1
查看7道真题和解析