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' ;