题解 | 很多问题冷静下来多思考也就迎刃而解了
牛客每个人最近的登录日期(二)
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 u.name order by date desc) rn from login l join user u on l.user_id=u.id join client c on l.client_id=c.id) t where rn=1 order by u_n
