题解 | 牛客每个人最近的登录日期(一)

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