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
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