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

with f as (select u.name as                                               u_n
                , c.name as                                               c_n
                , l.date
                , rank() over (partition by u.name order by l.date desc ) r
           from login l
                    inner join client c on l.client_id = c.id
                    inner join user u on l.user_id = u.id)
select u_n, c_n, date
from f
where r = 1;