题解 | #67#
牛客每个人最近的登录日期(二)
http://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
窗口函数+内连接+排序
易错点:遗漏按name排序
select user.name as u_n,c.name as c_n,date from( select user_id,client_id,date from( select user_id,date,client_id,row_number()over(partition by user_id order by date desc) as t from login ) sub where sub.t=1) a inner join user on a.user_id=user.id inner join client c on a.client_id=c.id order by user.name asc