题解 | #牛客每个人最近的登录日期(二)#
牛客每个人最近的登录日期(二)
http://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
select user.name u_n,client.name c_n,date
from login,user,client
where (user_id,date) in(select user_id,max(date) from login group by user_id)
and login.user_id=user.id and login.client_id=client.id
order by u_n
from login,user,client
where (user_id,date) in(select user_id,max(date) from login group by user_id)
and login.user_id=user.id and login.client_id=client.id
order by u_n
