题解 | 牛客每个人最近的登录日期(一)
牛客每个人最近的登录日期(一)
https://www.nowcoder.com/practice/ca274ebe6eac40ab9c33ced3f2223bb2
select user_id,date
from (
select user_id,date,row_number() over ( partition by user_id order by date desc ) as rk
from login
) as t
where rk =1
投递网易游戏等公司6个岗位
