#窗口函数的使用
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