UPDATE TEST2 T1
SET T1.E_DT = '20170501'
WHERE EXISTS (SELECT 1
FROM (SELECT NAME, MAX(E_DT) MX_DT FROM TEST2 GROUP BY NAME) T2
WHERE T1.NAME = T2.NAME
AND T1.E_DT = T2.MX_DT);
UPDATE TEST2 T1
SET T1.S_DT = '20170501'
WHERE EXISTS (SELECT 1
FROM (SELECT NAME, MAX(S_DT) MX_DT FROM TEST2 GROUP BY NAME) T2
WHERE T1.NAME = T2.NAME
AND T1.S_DT = T2.MX_DT);
