select name, phone
from (select name, phone, rank() over(partition by phone order by create_date desc) r from emp)
where r = 1;
select name, phone
from (select name, phone, rank() over(partition by phone order by create_date desc) r from emp)
where r = 1;