又是靠自己。。
通过Oracle的开窗函数over(partition by):
update TBL_SQZL
set HYJG = '1'
where ID = (
select t2.ID
from (select t.*,
row_number() over (
PARTITION BY t.ZJHM
ORDER BY
t.CRT_TIMESTAMP DESC
) as row_flg
from TBL_SQZL t) t2
where t2.JYTGM is not null
and t2.XM = '郭玉珍'
and t2.ZJHM = '310101194307254025'
and t2.ZJLX = '01'
and t2.row_flg = '1');