题解 | #牛客每个人最近的登录日期(二)#
#窗口函数的使用 select user.name,client.name,a.date from (select *, rank() OVER(PARTITION by user_id ORDER by date DESC) as number from login) as a left join user on a.user_id==user.id left join client on a.client_id==client.id where number==1 order by user.name
查看16道真题和解析