查询分组中时间最大的记录

select *
from (select a.*,
row_number() over(partition by a.hismzzyid_vchr order by a.createdate_dat desc) rn
from T_INS_NEWSZSYBREGISTER a)
where rn = 1