select user_id,id
from(select user_id,date id,row_number()over(partition by user_id order by date desc) rn from login) t
where rn=1
order by user_id