题解 | 牛客每个人最近的登录日期(一)
牛客每个人最近的登录日期(一)
https://www.nowcoder.com/practice/ca274ebe6eac40ab9c33ced3f2223bb2
SELECT user_id,
date
FROM (
SELECT user_id, date ,
DENSE_RANK() OVER (PARTITION BY user_id ORDER BY date DESC) rk
FROM login
) e
WHERE e.rk = 1
ORDER BY user_id;
select user_id,MAX(date) date
from login
group by user_id
order by user_id
查看20道真题和解析