oracle 查询最新时间的数据

SELECT t.id
FROM t_staff t
         left join (select *
                    from (select b.*,
                                 (row_number()
                                         over (partition by STAFF_ID order by CREATED_AT desc)) px
                          from R_STAFF_PLAN b) e
                    where px = 1) rsp on t.id = rsp.STAFF_ID
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/lhn9527/p/14182868.html