select *
from (select row_number() over(partition by CAR_ID order by create_time desc) rn, a.*
from table a where is_del = 0 )
where rn = 1
select *
from (select row_number() over(partition by CAR_ID order by create_time desc) rn, a.*
from table a where is_del = 0 )
where rn = 1