-- row_number 最简单用法
select
f_uid,
f_create_time,
f_type
from(
select
f_uid,
f_create_time,
f_type,
row_number() over (partition by f_uid order by f_create_time desc) as rn
from open.t_test
) tmp
where rn = 1;