update table a
     set a.date=(select max(b.date) from table b where b.stat_cd=a.stat_cd)