Oracle 获取不同分组中最近一条数据

```

select *
from (select t.*,
row_number() over(partition by t.khuserid order by t.CREATETIME desc) rn
from tables) t) c
where rn = 1

```