GaramX

UPDATE REP_INSUR_ACC
   SET end_ymd=(SELECT dbo.XF_NVL_D(dbo.XF_DATEADD(MIN(calc_ymd),-1) , X.end_ymd )
					  FROM REP_INSUR_ACC AS A
					 WHERE A.calc_ymd > X.calc_ymd
					   AND A.company_cd = X.company_cd
					   AND A.ctz_no = X.ctz_no
					   AND A.emp_id = X.emp_id)
  FROM REP_INSUR_ACC AS X
 WHERE 1=1
   AND X.company_cd  = 'E'
   AND X.ctz_no  = 'qzDppshPl9Oti+cRoA2hRQ=='
   AND X.emp_id  = '60487' 
;