Oracle about lead函数的使用。(可以找出数据在修改前和后)

Oracle 之lead分析函数打出当前记录某一字段修改前若干次的记录。

select  

decode(log.ACTN_CDE, 'UPDATE',

LEAD(log.ac_id, 1, NULL) OVER (PARTITION BY log.ipo_subs_id ORDER BY log.last_upd_time DESC NULLS LAST), null) prevAccountId，

 decode(log.ACTN_CDE, 'UPDATE', LEAD(log.ae_aces_grp_cde, 1, NULL) OVER (PARTITION BY log.ipo_subs_id ORDER BY log.last_upd_time DESC NULLS LAST), null) prevAeAccessGroupCode,
 from XXX