题解 | 牛客每个人最近的登录日期(二)
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
select u_n, c_n, date from
( -- 子查询是找到最早时间的
select u.name u_n, c.name c_n, date,
row_number() over(partition by l.user_id order by l.date desc) rn
from login l
inner join user u on u.id = l.user_id
inner join client c on c.id = l.client_id
) as l1
where l1.rn = 1
order by l1.u_n;
