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

# 每一个用户最近登录，用户名字，设备名
with
t1 as(
    select
        user.name as u_n,
        client.name as c_n,
        date,
        dense_rank()over(partition by user_id order by date desc) as drank
    from
        login
        left join user on login.user_id=user.id
        left join client on login.client_id=client.id
    order by
        u_n
)

select u_n,c_n,date from t1 where drank=1 order by u_n