select id,d_time,f_number
from (select id,d_time,f_number,rank() over(partition by id order by d_time desc) rk
from tbname) t
where t.rk=1;
from (select id,d_time,f_number,rank() over(partition by id order by d_time desc) rk
from tbname) t
where t.rk=1;
(select max(D_TIME) from 表 group by ID)