Oracle,创建一个存储过程，获取打印每个职工最新的一条变更信息。

[qq_37162969]

这是数据库

[nayi_224]

select *
  from (select t1.*,
               row_number() over(partition by t1.user_id order by t2.user_change_date desc) rn
          from t1, t2
         where t1.user_id = t2.user_id) t1
 where t1.rn = 1;